Changing the .csv export format.
Posted: Fri Apr 05, 2024 10:35 am
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,
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,