topic Re: how to get date serial number in QlikView

how to get date serial number

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using below code:

date(weekend(today(),-1),'MMDDYYYY')

now I want get the serial number of this date i.e if I get 06/17/2017, how can I get the date serial number for this date?

Thanks,

Sandip

Anil_Babu_Samineni — Thu, 22 Jun 2017 09:34:39 GMT

Serial number means, What was the output you are expecting from this date

henrikalmen — Thu, 22 Jun 2017 09:42:58 GMT

num(date(weekend(today(),-1),'MMDDYYYY'))

Peter_Cammaert — Thu, 22 Jun 2017 09:48:51 GMT

In his expression, Henrik shows you the QlikView date serial # which means that 1 = Dec 31, 1899. Today is day # 42908.

If you want a different serial number for todays date, please specify the starting date for your counter.

mohammadkhatimi — Thu, 22 Jun 2017 09:49:09 GMT

Just write num() you will get in numeric as a date..

Try below:

num(date(weekend(today(),-1),'MMDDYYYY'))

Hope this will helps u..!!

abc_18 — Thu, 22 Jun 2017 10:00:52 GMT

If you want to get serial number along with the date field , you can try using Dual function.

Dual(Text,Number).

Kushal_Chawda — Thu, 22 Jun 2017 10:19:02 GMT

try

floor(weekend(today(),-1))