3 Replies Latest reply on Jan 17, 2012 11:06 AM by philmodjunk

# Creating Date Calculations for Deadlines based on Event Dates (Need it in Months)

### Title

Creating Date Calculations for Deadlines based on Event Dates (Need it in Months)

### Post

I've searched and searched to the answer to my question but haven't seemed to be able to hit the nail on the head.

In my database I have a Job at that Job has a Date assigned to it.  I need a field that will calculate 8 Months from that date.  I have been able to do a simplistic version with just +days, but I need to to give me the right day and month.  So if the Job date is January 14th, the 8 month date would be August 14th.

Anyone have any suggestions?

Ian

• ###### 1. Re: Creating Date Calculations for Deadlines based on Event Dates (Need it in Months)

For a date numb months in the future, use:

Let ( D = EventDate ; Date ( Day ( D ) ; Month ( D ) + NumbMonths ; Year ( D ) ) )

You can put a field in place of the constant 1 to compute dates for a varying number of months in the future.

Note that for dates falling on the 28th through 31st, you cannot guarantee that the computed date will fall on the same day of the month as it may not actually exist. in those cases, the calculation will return a date in the first week of month + NumbMonths + 1.

• ###### 2. Re: Creating Date Calculations for Deadlines based on Event Dates (Need it in Months)

Date ( Day ( D ) ; Month ( D ) + NumbMonths ; Year ( D ) )

Reverse the Day and Month here. :^)

• ###### 3. Re: Creating Date Calculations for Deadlines based on Event Dates (Need it in Months)

Thanks! good catch on the syntax error.

Should be:

Let ( D = EventDate ; Date ( Month ( D ) + NumbMonths ; Day ( D ) ; Year ( D ) ) )