4 Replies Latest reply on Jan 25, 2014 8:27 PM by Swiper2727272

    How can i subtract a number(of days) from a DATE field ?

    Swiper2727272 Level 1

      I have a date field that can be manually entered in) 

      in (dd/mm/yyyy) format

      i'd like to be able to take this date and subtract  a number from it ( say 280 days)

      and have it come up with the date it would be 280 days in past in another field

       

      Date1   <  here

      subtract 280 days (as close as possible based on month/days per month etc.. )

      NewDate <--- here

       

      Can this be done at all ?

       

      TIA