How to convert Serial number back to date? - Qlik Community

Anonymous · ‎2017-11-21

Hi Everyone, I am new to Qlik View.

How to convert Serial number back to date??

I am failing to convert it, i used "

Date(Floor(Num#(YM, '##')), 'DD/MM/YYYY') as Date, and Date(Num#(YM, '##'), 'DD/MM/YYYY') as Date, " they are resulting to 1966 which is wrong.

sunny_talwar · ‎2017-11-21

What date is 24181 suppose to be?

m_woolf · ‎2017-11-21

The numbers shown in your YM field represent dates in 1966.

Or · ‎2017-11-21

Date(YM) should do the job.

Peter_Cammaert · ‎2017-11-21

This works for the data shown in your screenshot:

But we most certainly run into trouble for 2015.

As Sunny already mentioned, we need the calculation logic behind those weird serial numbers to be able to create a conversion expression that works reliably in every situation. If you don't know the logic, can you please tell us where you got them from?

The numbers themselves tell us nothing, and even when taking into account what is shown in the first column of your screenshot, they may quickly become ambiguous. For example, 24181 could be Jan-2014 or Nov-2013.