how to get last day of each month data

[#1]

Hi All,

I have a table . It contains two years data. I have one report, to show only the last day of each month values. I need to take all the records from table, but in one report i want to show only last day of each month values. Is there any function available in qlikview to get the last day of each month?

Thanks,

Raghu.

[hector]

Hi, use this function monthend(timestamp), it returns the last day of the month

rgds.

[johnw]

Note that monthend(date) returns the last millisecond of the last day of the month. You will likely need to use daystart(monthend(date)) to match your date field.

[hector]

or maybe use floor(monthend(date))