Date - (Month (CurrentDate)-1) 1

[cretanion]

Running this for January 2008.

Date ((Year (CurrentDate)),(Month (CurrentDate)-1) ,Day (Maximum (LastFullMonth)))

Why am I getting, "a month number must be between 1 and 12?" I think I know the answer, 1-1=0, but why? How do I get around this?

I am trying to get the lastfullmonth data, which is December 2007. Do I set a datevar=Month(CurrentDate)-1 and do an IF THEN statement?

Thanks in advance for your help,

 

[bdreed35]

I believe you can change your formula to use DateSerial rather than Date and it should work:

DateSerial ((Year (CurrentDate)),(Month (CurrentDate)-1) ,Day (Maximum (LastFullMonth)))

But an easier solution is to just do this:

Maximum (LastFullMonth)

~Brian

 

[cretanion]

DateSerial was the magic bullet,

Thanks.