Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

DATE TO NUMBER OF DAYS

Dear All

 

I want to get a number of days using given data

MARKETING_DATE - 31-05-2019 

 

sagara

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: DATE TO NUMBER OF DAYS

It's not clear number of days since when exactly ? 

If you mean number of days from the start of the year you can use the function DayNumberOf Year('05/31/2019')

nbyears.JPG

If you mean the number of days between a date in the past and today

use this expression : 

nbdays.JPG

Regards,

Mohamed

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: DATE TO NUMBER OF DAYS

It's not clear number of days since when exactly ? 

If you mean number of days from the start of the year you can use the function DayNumberOf Year('05/31/2019')

nbyears.JPG

If you mean the number of days between a date in the past and today

use this expression : 

nbdays.JPG

Regards,

Mohamed

View solution in original post

Highlighted
Creator
Creator

Re: DATE TO NUMBER OF DAYS

thanks boss it is work

 

can you help 

 

get a last month max date using following

MARKETING_DATE

 

sagara

Highlighted
Partner
Partner

Re: DATE TO NUMBER OF DAYS

MonthEnd(Max(Date(MARKETING_DATE)))

 

Mohamed