5 Replies Latest reply on Feb 13, 2019 5:57 AM by Norbert Maijoor

    Date Requirement

    Atul Sawant

      Hello All,

       

      I have a requirement where in need to create a new calculated field based on the date .

       

      As below for Jan month , for date 03-01-2019 the sum of rev in the calculated field should be dates from 01-01-2019  to 03-01-2019.

      Also for date   03-02-2019 the sum of rev in the calculated field should be dates from 01-02-2019  to 03-02-2019.

       

           

      daterevcalculated field
      01-01-20191010
      02-01-20192030
      03-01-20193060
      04-01-201940100
      05-01-201950150
      01-02-20191010
      02-02-20192030
      03-02-20193060
      04-02-201940100

       

      Let me know in case any more details are needed.