date format changed on export to CSV

[Former user]

The date format changed to YYYY-MM-DD from MM/DD/YYYY. I use the date in the CSV export in excel formulas. The new date format is not recognized by the excel formula : MONTH. Please provide an option to revert to the previous US date format

[Andriy Zhdanov]

Hi Jim,

I think it's just timezone added (due to issue#1131).

Thank you.

[Andriy Zhdanov]

Duplicate of #1133.

[Andreas Michael]

Hi Jim, for the date: "2017-08-29 17:54:00 +02:00" in a cell "U2", use:

=LEFT(U2,10) to get date only: "2017-08-29"

=RIGHT(LEFT(U2,19),8) to get time only "17:54:00"

=RIGHT(LEFT(U2,21),1) to get time zone +/- sign

=RIGHT(LEFT(U2,26),5) to get time zone hours "02:00"

After transformation, you can use Excel formulas on the cells containing transformed data as usual.

@azhdanov please don't change date formats again :)

[Andriy Zhdanov]

I'm eager to solve it somehow better, but still have no better idea than just making it configurable.

[Former user]

Making it configurable is desired versus making it better. The MONTH function is much easier than parsing functions in excel.

Configurable is the ‘better’ solution IMHO

James Gilbert, Vice President Network Solutions Red Lion Controls | www.redlion.nethttp://www.redlion.net/ [phone] x5108 office [phone] mobile

[Former user]

So instead of using the MONTH function, you want me to do that……

I replied to Andriy to just make it configurable to the previous and this format.

James Gilbert, Vice President Network Solutions Red Lion Controls | www.redlion.nethttp://www.redlion.net/ [phone] x5108 office [phone] mobile

[Andriy Zhdanov]

Hi,

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.