Converting Date Issue

Follow

Dean Villegas

• February 25, 2016 18:41

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?

0

• 

  Jason Arrigo

  • February 25, 2016 18:46

  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

  Comment actions Permalink

Please sign in to leave a comment.