Using Dates in Formulas

[tlewis]

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

[Thableaus · Accepted solution]

Hi  @tlewis 

Try this:

If ToDate([TermDate]) >= ToDate(DateTimeAdd([TermDate], 2014 - DateTimeYear([TermDate]), "years"))
Then "Yes"
Else "No"
Endif

When comparing dates with DateTime formulas, you have to be sure they are Dates and not in DateTime format.

Otherwise, you can get unexpected results.

Cheers, 

[Thableaus · Accepted solution]

If ToDate([TermDate]) >= ToDate(DateTimeAdd([TermDate], 2014 - DateTimeYear([TermDate]), "years"))
Then "Yes"
Else "No"
Endif