Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
num(date(weekend(today(),-1),'MMDDYYYY'))
Serial number means, What was the output you are expecting from this date
num(date(weekend(today(),-1),'MMDDYYYY'))
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.
Just write num() you will get in numeric as a date..
Try below:
num(date(weekend(today(),-1),'MMDDYYYY'))
Hope this will helps u..!!
If you want to get serial number along with the date field , you can try using Dual function.
Dual(Text,Number).
try
floor(weekend(today(),-1))