Discussion Board for collaboration related to QlikView App Development.
I have a set of data in excel..
My date field are in numbers......
like 01/01/2017 becomes 42736....
Please how can I manipulate it back to DD/MM/YYYY in the qlik environment..
see attached for sample
Try to use Date(FieldName, 'DD/MM/YYYY')
Hello sir... Thanks for the assistance...
I used the script for the date in numeric format and I got my date field in DD/MM/YYYY
Date(Num#(Date)) as Date,...
but the challenge is on my chart title... I used this expression... ='Sales Figures as at max(Date)'... to get the latest date... It's showing me numbers not date
Because Max() only works on numbers, not on dates, it will always return the numerical value that underlies your date. You will have to format it into a date again, just like Marcus says.
Thank you Antonio....