Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Re: how to get date serial number

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

View solution in original post

6 Replies
Highlighted

Re: how to get date serial number

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

Re: how to get date serial number

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

View solution in original post

Highlighted

Re: how to get date serial number

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.

Highlighted
Partner
Partner

Re: how to get date serial number

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

Try below:

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


Hope this will helps u..!!

Highlighted
Creator II
Creator II

Re: how to get date serial number

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

Dual(Text,Number).

Highlighted

Re: how to get date serial number

try

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