Adding 30 days to a date

[guigui17]

Dear all ,

I am trying to add 30 days to a date in order to create a "If statement" in a Formula. 

Here below is the formula that I wrote that is clearly not in correct - if you could help me with that , this would be greatly appreciated.

thanks a lot in advance,

Guillaume 

[Kenda · Accepted solution]

Hi there @guigui17 

It looks like you're close! In the first part of your if statement, however, you do not need the 

[Capture date] +

Instead, replace the "dt" in your DateTimeAdd expression with this field name.

Hope this helps! 

[Qiu · Accepted solution]

@guigui17 

There is an error in the DateTimeAdd formula I think.

[jferrone · Accepted solution]

I believe this is the formula you need

IF DateTimeAdd([Capture date], 30, 'days') < [Payment date]
THEN 'Paid within Service Agreement'
ELSE 'Not with Service Agreement'
ENDIF