I'm not very familiar with expression builder and I would like to evaluate a control with a value, something like this:
if current month is > 6 then
"currentYear" & "/" & "(currentYear + 1)" e.g. "2007/2008"
otherwise
"(currentYear - 1)" & "/" & "currentYear" e.g. "2006/2007"
tried:
IIf(Month > 7, StrConv(Year) & StrConv(Year + 1), StrConv(Year - 1) & StrConv(Year))
...but access 2k3 doesn't like it.
Any suggestions appreciated,
thank you
-luis
if current month is > 6 then
"currentYear" & "/" & "(currentYear + 1)" e.g. "2007/2008"
otherwise
"(currentYear - 1)" & "/" & "currentYear" e.g. "2006/2007"
tried:
IIf(Month > 7, StrConv(Year) & StrConv(Year + 1), StrConv(Year - 1) & StrConv(Year))
...but access 2k3 doesn't like it.
Any suggestions appreciated,
thank you
-luis