Changing the .csv export format.

[JohnBox]

Hey all,

I want to export a .csv for use in Excel, is there a way to format "Date Created" to only show the date and not the time? I currently have it set to dd/MM/yyyy and then time= t so I just get "A" or "P" to minimise it, but would ideally like no time information.

And then a second question, when I do export the .csv, it seems to ignore formatting done in the .ini file and gives a yyyy-MM-dd 00:00:00, if that makes sense?

Screenshot included to help make sense.

Any tips would be super appreciated!

Many thanks,

[void]

The easiest way would be to remove the time in Excel.

Add a new column and set the formula to:

=DATE(YEAR(A1),MONTH(A1),DAY(A1))


Everything always exports date/times with CSV as: yyyy-MM-dd HH:mm:ss

[JohnBox]

Thanks for the speedy reply, worth a shot! An extra thank you for giving me the formula too!

Really appreciate it.