Need help with a couple of issues relative to the "dates" field in the standard database module.
1. When exporting into csv, the date field is a series of numbers (some type of code) and I am unable to format it to read as the actual date.
2. I need to upload several entries via csv. I am unable to get the date field correct. It always defaults to 1 January 1970.
I'm sure it's a simple fix or setting. Any help would be greatly appreciated.
Thanks Itamar for the formula for converting Unix timestamps.
I just came across a tracker issue, MDL-32637, requesting dates to be converted on export, if anyone wishes to vote for this improvement to be implemented.
The Dataform can export dates in almost every format. It also imports dates from date strings. So anyone who wishes to attempt the improvement in the Database module is welcome to take some ques from the Dataform code.
I just encountered the issue this morning - having human readable dates exported from database activity is a must have for using database effectively. I've seen the workaround conversion that can be run on a spreadsheet - not difficult, but a step beyond any staff who aren't computer confident.