Calculating date 90 days past identified date

kylavalley

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. 

rob_marshall

Kylavalley,

 

Simply add 90 to the date as in the below:

 

Let me know if this helps,

 

Rob 

 

 

LipChean_Soh

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

kylavalley

Thats simple enough! 

 

Thanks, Rob