Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert Numbers (41292) to Dates

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

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

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

- Marcus

swuehl
MVP
MVP

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;