4.1 - Date minus 1?

[Former Member]

Hi,

Trying to rebuild some older reports in our new 4.1 system, but I can't get one of the variables to work -

I am trying to get the month, minus 1 day of the current date, so that it matches the date our system shows as (always one day behind today). Normally we would do:

=Month(CurrentDate()-1)

but when I do this I get the error: IES 10037 - The expression or sub-expression at position 7 in the '-' function uses an invalid data type.

Is there a new way of calculating this in 4.1 that anyone knows of? I can't find anything in the help files we were given.

Thank you

[tanveer1]

Hi ,

Use below formula

= month(relativedate(currentdate();-1))

Thanks,

Tanveer