My workflow creates a progress report of sorts relying lot on date or datetime fields. The report works fine but a colleague of mine wants to do some explorative statistics via Excel and some Power Whatever, so I dump the data via the Excel Writer node.
Now he has two problems with the dump resulting from fact that Excel Writer uses a customized format cell instead of date format:
- The date format is set by the workflow and does not conform to his local Excel settings
- The MS Power Whatever is not recognizing the customized format fields as dates, though Excel does this correctly
Is there any possibility to force the node to output plain date cells?