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. 

Answers

  • 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 

     

     

  • 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

  • Thats simple enough! 

     

    Thanks, Rob