Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
akpofureenughwu
Contributor II

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
antoniotiman
Honored Contributor III

Re: Date in Numerical form

Use MaxString(Date)

6 Replies

Re: Date in Numerical form

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

Life is so rich, and we need to respect to the life !!!
akpofureenughwu
Contributor II

Re: Date in Numerical form

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 

Re: Date in Numerical form

Use: date(max(Date))

- Marcus

Re: Date in Numerical form

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
Honored Contributor III

Re: Date in Numerical form

Use MaxString(Date)

akpofureenughwu
Contributor II

Re: Date in Numerical form

antoniotiman

Thank you Antonio....

Regards

Community Browser