Hello In an app I have tow fields as follow...

(Tim O'Neill) #1

Hello

In an app I have tow fields as follows, “Inspection Date” and “Next inspection due”. Is there a formula I can use to populate the “next inspection due” automatically 3 months from the date entered as Inspection date?

(Philip Garrett) #2

You can try

[Inspection Date]+91

That adds 91 days to the Inspection Date which is very close to 3 months.

(Aleksi Alkio) #3

If you need the exact date + 3 months, it’s doable but it would be quite complex. Because of that, I would prefer to use Philip’s workaround.

(Tim O'Neill) #4

@Philip_Garrett_Appsh That works great thanks Philip