August 21, 20187 yr Newbies 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
August 21, 20187 yr 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.
Create an account or sign in to comment