Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date field ASS_DUE_DATE that shows on the table numbers like 41292
In the data load Date(ASS_DUE_DATE, 'MMDDYYYY')
But did not convert the numbers to dates
How can I change the numeric value to dates so the table using this field will show the correct date
Thank you
Are you sure that your values are really numeric? You could try it with:
Date(num#(ASS_DUE_DATE), 'MMDDYYYY')
- Marcus
The Date() function should work, like
LOAD
ASS_DUE_DATE,
Date(ASS_DUE_DATE, 'MMDDYYYY') as ASS_DUE_DATE_FORMATTED,
...
FROM ....;
Could you post a screenshot of a tablebox that shows these two fields?
Try this you have to convert it to NUM and then convert to date format.
Load
ASS_DUE_DATE,
Date(Num#(ASS_DUE_DATE,'#####'), 'MMDDYYYY') as NEW_ASS_DUE_DATE
Date(Num(ASS_DUE_DATE), 'MMDDYYYY') as NEW_ASS_DUE_DATE_2
From Source;