topic Re: How to convert Numbers (41292) to Dates in QlikView

How to convert Numbers (41292) to Dates

Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 06 Sep 2017 08:20:43 GMT

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

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

- Marcus

swuehl — Wed, 06 Sep 2017 08:22:17 GMT

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 — Wed, 06 Sep 2017 08:28:14 GMT

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;