Date in Numerical form

[akpofureenughwu]

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

[Anil_Babu_Samineni]

Try to use Date(FieldName, 'DD/MM/YYYY')

[akpofureenughwu]

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 

[marcus_sommer]

Use: date(max(Date))

- Marcus

[Peter_Cammaert]

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.

[antoniotiman · Accepted solution]

Use MaxString(Date)

[akpofureenughwu]

antoniotiman‌

Thank you Antonio....

Regards