Adding 30 days to a date

Question

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

Question to the community Ap analysis.yxzp

Kenda · Accepted Answer

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 Answer

@guigui17

There is an error in the DateTimeAdd formula I think.

jferrone · Accepted Answer

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