Get Day in Month

[#1]

Hello,

I would like to get number of day in Month. How to write script in Qlikview?

Thank,

Ratana

[Sokkorn]

Hi Ratana,

Let try :

Round(MonthEnd(DateField)-MonthStart(DateField))     AS [NumberOfDay]

Regards,

Sokkorn

[er_mohit]

Day(DateFieldname) as Day

[#4 · Accepted solution]

round(MonthEnd(Today())-MonthStart(Today()))  as [no_of_days]

OR TRY THIS

Day(MonthEnd(Makedate(Year(Today()))))   AS   [No_of_day]

[#5]

Thank for your reply....

What i expected is getting number of each month:

Ex:

Jan-2013     is 31

Feb-2013     is 28

How to get this?

Regards,

Ratana

[#6]

try this

round(MonthEnd(Date(datefield,'MMM-YYYY'))-MonthStart(datefield,'MMM-YYYY'))  as [no_of_days]