
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to convert Serial number back to date?
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What date is 24181 suppose to be?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The numbers shown in your YM field represent dates in 1966.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date(YM) should do the job.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
