how to get date serial number

[ananyaghosh]

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]

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

[henrikalmen · Accepted solution]

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

[Peter_Cammaert]

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]

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]

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

Dual(Text,Number).

[Kushal_Chawda]

try

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