2 Replies Latest reply on Aug 9, 2018 4:52 AM by Zhouyi Zhang

    Extract the same day and month in last year

    Pak Hang  Leung

      Hi all

       

      Now I have a problem with extracting the same period in last year.

      The first is, we would like to extract the sales for last week. For example, now is 8-9-2018 (Thursday), and what I need to do is to extract the sales for whole last week i.e  30-Jul-2018 (Mon) to 5-Aug-2018(Sun)

      For this, I use the following command:

      However, now I want to extract the same date value for last year i.e 30-Jul-2017 to 5-Aug-2017. I tried to use the following function:

      However, it does not return the value exactly in the same period, and I suspect that it is because of the different in week number.

      If I want to extract the same date value for last year, what should I do then?

      Many thanks!