Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate number of days

How do we calculate the number of days in a month?

1 Solution

Accepted Solutions
Nicole-Smith

Or even simpler:

day(monthend(DateField))

View solution in original post

4 Replies
Nicole-Smith

round(monthend(DateField)-monthstart(DateField))

vamshi_1957
Creator II
Creator II

=Day(Monthend(Date Field))-Day(Monthstart(Date Field))

Nicole-Smith

Or even simpler:

day(monthend(DateField))

VishalWaghole
Specialist II
Specialist II

Hi Anitha,

You can try,

Day(MonthEnd(DateField)) as NoOfDays

- Regards,

Vishal Waghole