Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Date in Numerical form

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

1 Solution

Accepted Solutions
6 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
akpofureenughwu
Creator III
Creator III
Author

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
Partner - Champion III
Partner - Champion III

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
Master III
Master III

Use MaxString(Date)

akpofureenughwu
Creator III
Creator III
Author

antoniotiman

Thank you Antonio....

Regards