topic Re: Date in Numerical form in QlikView

Date in Numerical form

akpofureenughwu — Fri, 05 May 2017 14:30:41 GMT

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

Re: Date in Numerical form

Anil_Babu_Samineni — Fri, 05 May 2017 15:47:04 GMT

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

Re: Date in Numerical form

akpofureenughwu — Mon, 08 May 2017 12:03:14 GMT

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

marcus_sommer — Mon, 08 May 2017 12:57:21 GMT

Use: date(max(Date))

- Marcus

Re: Date in Numerical form

Peter_Cammaert — Mon, 08 May 2017 13:34:27 GMT

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.

Re: Date in Numerical form

antoniotiman — Mon, 08 May 2017 13:50:49 GMT

Use MaxString(Date)

Re: Date in Numerical form

akpofureenughwu — Tue, 09 May 2017 07:30:20 GMT

antoniotiman‌

Thank you Antonio....

Regards