Data type operations

[vvissamsetty]

I have 2 columns with dates. I'm trying to create a check function where if Column A < (Column B - 90 days) then its 'True' else 'False'. It would be great if anyone can help me with this.

[Thableaus · Accepted solution]

Hi @vvissamsetty 

Try this - using Formula Tool:

IF Column A < DateTimeAdd(Column B, -90, "days") THEN "True" ELSE "False" ENDIF

Cheers,

[vvissamsetty]

That worked. Thanks @Thableaus