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,
Changing the .csv export format.
Changing the .csv export format.
- Attachments
-
- date created examples.png (14.97 KiB) Viewed 742 times
Re: Changing the .csv export format.
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
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
Re: Changing the .csv export format.
Thanks for the speedy reply, worth a shot! An extra thank you for giving me the formula too!
Really appreciate it.
Really appreciate it.