Converting Date Issue

2 followers
0
Avatar

Hi;

 

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?

Dean Villegas

1 comment

  • Avatar
    Jason Arrigo

    Hi Dean,

    • ASDATE(#time_stamp;"yyyy-mm-dd HH:mm:ss z")

     

    In the Formula you posted (above) you aren't distinguishing between Months (capital M) and Minutes (lowercase m).

    Try this one:

    • ASDATE(#time_stamp;"yyyy-MM-dd HH:mm:ss z")

    Best,
    Jason

     

    1
Please sign in to leave a comment.