Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
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
lazurens
Partner - Contributor III
Partner - Contributor III

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
lazurens
Partner - Contributor III
Partner - Contributor III

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

sagaraperera
Creator
Creator
Author

thanks boss it is work

 

can you help 

 

get a last month max date using following

MARKETING_DATE

 

sagara

lazurens
Partner - Contributor III
Partner - Contributor III

MonthEnd(Max(Date(MARKETING_DATE)))

 

Mohamed