Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

how to find day count

how to find day count

3 Replies
martin59
Valued Contributor II

Re: how to find day count

What do you mean ?

NumberOfDaysBetween2Dates=Date1-Date2

Hope that helps you

Martin Favier

Re: how to find day count

Hi

Use interval() function

For Ex:

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

hope it helps

Gabriel
Valued Contributor III

Re: how to find day count

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