Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Calculate number of days

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

1 Solution

Accepted Solutions

Re: Calculate number of days

Or even simpler:

day(monthend(DateField))

4 Replies

Re: Calculate number of days

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

vamshi_1957
Contributor II

Re: Calculate number of days

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

Re: Calculate number of days

Or even simpler:

day(monthend(DateField))

vishalwaghole
Valued Contributor II

Re: Calculate number of days

Hi Anitha,

You can try,

Day(MonthEnd(DateField)) as NoOfDays

- Regards,

Vishal Waghole

Community Browser