I am having trouble with the below calculation:

Case

(

Month ( Get ( CurrentDate ) ) = 1 or Month ( Get ( CurrentDate ) ) = 2 ; (Year ( Get ( CurrentDate ) ) - 1) ; Year ( Get (CurrentDate ) )

)

In the data view it works correctly. The problem I am having is that today the value did not update to 2008 but rather stayed at 2007.

This is a global calculation field used in a multi-predicate relationship.

Any ideas?

Thanks,

Drew

It needs to be unstored, not global.

That is what I figured... I was hoping someone had an idea for a work around...

I think I will change it to a number global and set the field in the start up script.

If it's for a relationship, an unstored calc will work as well as a global.

Problem solved. I changed the calculations to reference a global that is set during start up on the same table. See I needed a Year for today, minus 1 month and minus two months. the minus 1 and 2 months fields just look to the current year global which is the one being set.

Thanks for the help :

Drew

I moved Kirks post as you were replying.

See Trouble with a Calculation, in this Topic Area.