Hi All,
I'm always getting the error message when I try the following:
Int("99"+CStr(IIf(Day([tblActuals]![ActualsDate])<10,"0" & CStr(Day([tblActuals]![ActualsDate])),Day([tblActuals]![ActualsDate])))+CStr(IIf(Month([tblActuals]![ActualsDate])<10,"0" & CStr(Month([tblActuals]![ActualsDate])),Month([tblActuals]![ActualsDate])))+CStr(Year([tblActuals]![ActualsDate])))
What I want with the expression is that the ActualsDate is concatenated behind the String "99" and then turned into an Integer e.g. 9907032024.
Access indicates the error on the first "0".
Any ideas?
Best regards
Johan