18 Replies Latest reply: Sep 13, 2017 7:27 AM by Antonio Mancini RSS

    Date range

    UPALI WIJERATNE

      I have some sales data stored in a table in date order

       

      Date                Sales

      01-01-2017     5000

      02-01-2017    10000

      ......

      31-08-2017    12000

       

      I want to extract data for the following Periods

      1.   1st to 14th of the month  Eg 01-01-17 to 14-01-17

      2.   15th to 31st  of the month Eg: 15-01-17 to 31-01-17

      3.    15th to 14th (two months) Eg : 15-01-17 to 14-02-17


      How can I do this in script or master calendar pls help