Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

how to get date serial number

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

1 Solution

Accepted Solutions
henrikalmen
Creator
Creator

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

View solution in original post

6 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
henrikalmen
Creator
Creator

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

View solution in original post

Peter_Cammaert
Partner
Partner

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
Partner
Partner

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
Creator II
Creator II

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))