Date Calculation

[Robin Neeves]

Hello and Thank you for your help

I need to create date calculations, Objective to use a date that I enter in to a field and then calculate a due date.

For ensample: Field Date is 20/06/2018 add 1 month = 20/07/2018, 2 month = 20/08/2018, 3 month = 20/09/2018 so on.

So I need a field that I enter the number of months in 1 to 12, (Frequency Field),  a date field where I enter a date manually (Last Inspection Date).     

Then I need a date field that calculates the date I entered (Last Inspection Date) and number of months (Frequency Field) to calculate the next due date.

Regards Robin

[Agnes Riley]

Dates calculate in days. So if you need to calculate a month from now you need to enter yourDate + 30 to get that.

Ther are a lot of custom functions on briandunning.com if you need something more complicated.