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: 
Not applicable

how to find day count

how to find day count

3 Replies
martin59
Specialist II
Specialist II

What do you mean ?

NumberOfDaysBetween2Dates=Date1-Date2

Hope that helps you

Martin Favier

MayilVahanan

Hi

Use interval() function

For Ex:

Interval(Today()-(Today()-2),'D') gives 2

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

If I understand you well, you want to know the function to count the day of the year?

If that is the case,use this function

=DayNumberOfYear(Today(),1)

1 is the number of the month

Let me know if it works.

Regards,

Gabriel