Skip to Content
0
Former Member
Feb 27, 2009 at 12:52 PM

Previous Year Description/Formula

26 Views

Hi folks,

I use BOXI r2 sp 4. If I use the following variable to retrieve the current year; how do I modify it to return the previous year and the next year? Also, if someone could explain the logic to their solution, I would greatly appreciate it.

Type = character

Format = yyyy-MM

>=Substr([Billing Year Month];1;4)

Thanks!

W.