I have an issue that occurs in ALL of my workflows. Randomly, the first row of data written to Excel defaults to a data type of General and therefore date fields end up in the Excel data format of floating point. Every row thereafter is formatted, correctly, as a date (Custom data type).
Example:
All first row date field(s) format: 41787
All rows after the first row format: Jan 09, 2017
Is there a fix/reason this is happening? This is not a new issue. it's been happening since FME 2016.
Hi @rick_williams,
I can't reproduce this issue with FME 2017 (on Mac...). But I didn't specify a custom data type: I simply set the Type field to "date" and then all rows have the correct formatting (e.g. Jan 09, 2017), also when I don't write the column names.
If you did change the Formatting, what did you fill in in the Custom Number Format field?
Also, what is the attribute value you are trying to write? Is it a string (formatted with the DateFormatter for instance) or a numeric value?
This is a snap shot of my workflow and the results.
My current build is 2017.0.1.1 (20170512 17291 Win64)
This is a snap shot of my workflow and the results.
My current build is 2017.0.1.1 (20170512 17291 Win64)
This is a snap shot of my workflow and the results.
My current build is 2017.0.1.1 (20170512 17291 Win64)