Find number of days in present month

[#1]

Hi all,

How can i find the number of days in the month?

Regards,

Pramod

[tamilarasu · Accepted solution]

=Num(MonthStart(Max(DateField)) - MonthEnd(Min(DateField)))

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

[Kushal_Chawda]

If you already have year and month calculated from date. You can use below expression

= sum(aggr(count(Date),Year,Month))

[Anonymous]

something like:

= sum(aggr(count(day(Date)),Month))

[jagan]

Hi,

Try like this

LOAD

*,

Num(MonthStart(DateField) - MonthEnd(DateField) + 1) AS NumberOfDaysInMonth

FROm DataSource;

Hope this helps you.

Regards,

jagan.

[tresesco]

Day(Monthend(Today()))