Contributor

Calculating date 90 days past identified date

Hello - 

 

I am looking to calculate the date 90 days past an identifided date. I know there is an ADDMONTH and ADDYEARS calculation, but not an ADDDAYS, which would have been helpful. Is there another approach to do this? 

 

Example: What is the date 90 days from 11/15/18. 

 

Thanks

K. 

3 REPLIES 3
Community Boss

Re: Calculating date 90 days past identified date

Kylavalley,

 

Simply add 90 to the date as in the below:

2018-11-15_08-50-45.png

 

2018-11-15_08-50-36.png

Let me know if this helps,

 

Rob 

 

 

Contributor

Re: Calculating date 90 days past identified date

Thats simple enough! 

 

Thanks, Rob

Highlighted
Community Boss

Re: Calculating date 90 days past identified date

Hi K,

 

You just need to do a '+', i.e.

Date 2 = Date 1 + 90

 

Then Date 2 will be 90 days after Date 1.

 

Note the following:

1. Both must have Date format

2. Try to put in a logic to prevent blank dates.

 

Thanks