MaxDate per Month

Hi,

following situation is given:
BIRT 2.5.0 installed
Datasets are loaded via indicators, so there is no possibility to directly select data from the database!

In the dataset is a date column included. I need a script with wich i can identify if the date entry is the max entry for the year/month....

example:
Date Column -> check
=======================
01.01.2009 -> false
12.01.2009 -> false
30.01.2009 -> true
01.02.2009 -> true
01.02.2009 -> true
11.03.2009 -> true
30.04.2009 -> true
01.05.2009 -> false
11.05.2009 -> false
21.05.2009 -> true

At the moment i make it for each month/Year seperatly. That means i use this:
Aggregation on max(date) "where"
BirtDateTime.year(row["histDate"]) == 2009 && BirtDateTime.month(row["histDate"]) == 12

does someone know how i can fix the problem?

Cheers
Kai

Find more posts tagged with

Comments

mwilliams

Hi Kai,

What's the purpose in knowing this information? If you use an aggregation within a grouped table vs in a computed column, you can figure the max date out for the month date group.

kik007

Hi Michel,

i need to filter the date by the last of the month. After i have filter the date, i want to create a cross table with the entries grouped by year / month and only for the last of the month.

I also tried to use the "last function" on the crossTab. But the effect was not what i want.

Cheers
Kai

mwilliams

Kai,

Why does the "LAST" aggregation not work for you? Are there possibly multipe lines from the last date of each month that need to be added together?