Let ( T = Get ( CurrentDate ) ; Date ( Month ( T ) ; Day ( T ) : Year ( T ) + 1 ) )
in place of Get ( CurrentDate ) + 5
Set Field [YourTable::YourDateField ; Get ( CurrentDate ) + 5 ]
I tried this but FM wouldn't accept it. It said an operator was required. I replaced ";" with "=" and this was accepted by when the scrip was run nothing changed in my date field. Am I missing something?
What I am trying to do is increment the year of the date in my ExpiryDate field by one year.