How to convert Numbers (41292) to Dates

[#1]

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

[marcus_sommer]

Are you sure that your values are really numeric? You could try it with:

Date(num#(ASS_DUE_DATE), 'MMDDYYYY')

- Marcus

[swuehl]

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?

[its_anandrjs]

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;