I have a date field that is like "2016-02-24 00:09:43 UTC". Ironically, when I try to convert the date either in the export or using ASDATE command, it converts the date to "Jan 1, 2016 00:09:43 AM" rather than "Feb 24, 2016 00:09:43 AM". This is the command I used:
ASDATE(#time_stamp;"yyyy-mm-dd HH:mm:ss z")
Did I do something wrong? How can I fix it?
Please sign in to leave a comment.