Hello Accessers,
I am experiencing an 'Invalid Use of Null' issue with this expression:
Code:
Anniversary Date: CDate(CStr(DatePart("m",[initialaccreddate]))+"/"+CStr(DatePart("d",[initialaccreddate]))+"/"+CStr(DatePart("yyyy",Now())))
On one database it works. But when I copy the same on another database and then the same expression does not work. It shows "Invalid use of Null" error.
The field initialaccreddate is the same on both databases.
What is the culprit of the issue?!
Your help will be thanked and a star will be given for your reputation!
-ME