This is a basic one but need a little help. I need a text box to pop up an alert if the current date is more than 365 since the last recorded date in a table.
Here is the code I am trying to use for this, however I'm getting "#Error" when I give it a shot.
=IIf(DMax("EventDate","PMEvents","AssetID = " & [Forms]![Asset Details]![AssetID])-Int(Date())>365,"ONE YEAR PM PAST DUE")
I think it has something to do with not using an Integer as the first expression, and I'm unsure if you can have an Int() point to an unlinked table and referenced via a current forms ID # (such as can be done with Domain functions).
Any help is greatly appreciated, thx!