18 Replies Latest reply: Dec 27, 2017 7:12 AM by Sunny Talwar RSS

    Sales Last Year Same Month Day

    Mohammad Adnan Ansari

      I am working Sales table have 3 years data with the below attributes:

       

      [Date]

      [Sales Amount]

       

      The requirement is to show a TABLE where for each [Date], Sales for Last year same Month day should also come.

       

      For example: Against the date 10-Dec-2017, the last year same Month day sales also come which is sales for 11-Dec-2016. (Sunday this month same as sunday last year same Month which is 11th december).

       

       

      If I subtract 364 from [Date]; it will give me Last Year Same day.