IF statment not working

Question

I have a if formula IF [ID]=[id] THEN [DATE]+1 ELSE "" ENDIF

date is formatted  2020-05-20 00:00:00

what I would want ID=ID then date =2020-05-21 00:00:00

the error message I get is  Formula (25) Parse Error at char(0): Type mismatch in operator +. (Expression #1)

Kenda · Accepted Answer

Hey @Primus

The key here is that in order to add dates, you must use the DateTimeAdd() function!

So long as your field is recognized as a date, you should be able to use this expression:

IF [ID]=[id] THEN DateTimeAdd([DATE],1,"days") ELSE "" ENDIF

Hope this helps!