I do not understand why the formula result below is "No" (i.e. false). Both dates in the criteria are "2014-07-14" so I would expect the formula result to be "Yes" (i.e. true.)
If [TermDate] >= DateTimeAdd([TermDate], 2014 - DateTimeYear([TermDate]), "years")
Then "Yes"
Else "No"
Endif
Solved! Go to Solution.
Hi @tlewis
Try this:
If ToDate([TermDate]) >= ToDate(DateTimeAdd([TermDate], 2014 - DateTimeYear([TermDate]), "years"))
Then "Yes"
Else "No"
Endif