- changed status to resolved
.csv export now has timezone info in date columns
Starting today the Date Started column in the timesheet report includes timezone info when exported to csv. This breaks our processes as Excel does no longer recognise this column as a date. csv export last Friday: 2017-08-01 08:58:00 csv export today: 2017-08-01 08:58:00 +01:00
Comments (6)
-
-
reporter Genius. Fix an edge case for one customer and break Excel import for everyone else. By adding the timezone offset you have reduced the Date Started field from a date field to a text field. Well done.
-
Please let me know if there is better way to include timezone offset.
I've thought of removing space before offset, but I don't think it will be valid format then.
Do you thinkk it should be 2017-08-01T08:58:00+01:00?
-
Issue
#1157was marked as a duplicate of this issue. -
Hi Ronald,
As you might have noticed, I have removed timezone offset in export files, and restored original behaviour, i.e. converting time to current user time zone. Note, I've just added Preserve Started Time add-on configuration option for issue
#1131.Thank you.
-
reporter Thank you, much appreciated!
- Log in to comment
Hi Ronald,
This is by intention, due to issue
#1131.There is timezone offset included, because time is in worked user timezone, which may be different than currently logged in user, so it may be not accurate unless offset is included.
Please adjust your processing, and sorry for inconveniences caused.
Thank you.