7 Replies Latest reply on Jul 13, 2017 5:31 PM by fitch

    calculation to change date x number of weeks based on today

    m.mcdonell

      I have a service company. We use a frequency drop down currently with months. I have a calculation that takes the completed service date and adds the frequency of months to give me a next service date.

      How do I change this frequency to be days or weeks?

       

      My current calculation is -

      Date (Month ( Previous Service Date ) + Service Frequency ; Day ( Previous Service Date ) ; Year ( Previous Service Date ))