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:



      [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.