I have a column which holds the date but as a string. Its in GMT so I need to convert it to EST as well.
The original date as string, looks like this:
14-SEP-19 05.06.25.734000 PM
Before I can convert it, I have to change it to a date field so I used ASDATE function:
ASDATE(#MODIFIED_DATE; 'dd-MMM-yy HH.mm.ss')
But the result it outputs is:
2019/09/14 5:06:25 AM
So its converting the date and time ok, but not the PM, for whatever reason its converting it to the opposite - AM.
Any reason for this?
I have tried changing the function to include the "a" at the end as part of the format like this:
ASDATE(#MODIFIED_DATE; 'dd-MMM-yy HH.mm.ss a')
But it returns an error that it cant parse the string.
Please sign in to leave a comment.