Changing the .csv export format.

If you are experiencing problems with "Everything", post here for assistance.
Post Reply
JohnBox
Posts: 2
Joined: Fri Apr 05, 2024 10:17 am

Changing the .csv export format.

Post by 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,
Attachments
date created examples.png
date created examples.png (14.97 KiB) Viewed 740 times
void
Developer
Posts: 17152
Joined: Fri Oct 16, 2009 11:31 pm

Re: Changing the .csv export format.

Post by 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
Posts: 2
Joined: Fri Apr 05, 2024 10:17 am

Re: Changing the .csv export format.

Post by JohnBox »

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

Really appreciate it.
Post Reply