Discussion Board for collaboration related to QlikView App Development.
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
Are you sure that your values are really numeric? You could try it with:
The Date() function should work, like
Date(ASS_DUE_DATE, 'MMDDYYYY') as ASS_DUE_DATE_FORMATTED,
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.
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