Calender Expressions

[bharath28]

Hi Experts,

The below expressions carries the column from master calendar. So I expect these expressions to pick the values present in

the master calendar table. However when I say =max(Year)-5 it gives the output as  1998, whereas I expect the output to be 0 as 1998 is not present in the master calendar table.

Could you please guide me where I am doing wrong.

=Max(CalYear)-15

My other query is the below expression gives output as Jan, but I expect it to give Oct, which is the latest month in master

calendar.

=month(max(CalMonth))

Please guide me with the correct expressions.

Regards,

Bharath

[swuehl]

Bharat,

your max(Year) is probably 2003, and this is the only information retrieved from your master calendar in your first expression. Then you subtract 5, which is just executed as a mathematical operation

=2003-5 = 1998

There will be no check if 1998 is part of your year data.

=month(max(CalMonth))

returns Jan, e.g. if CalMonth is already in a format with a numerical representation 1-12 for the months.

So just try

=max(CalMonth)

What do you get?