Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Weekday current year vs last year

HI Anonymous   I have seen lots of posts, but i havent been able to implement this in my case.    basically i want to do this functionality   on monday, it should show fridays sales CY and frid...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    No, 

     

    This wont work for me.  MTD and YTD is no problem. What i am struggling with  is 

    eg. 

    today monday 1/21/2019 

    it should fetch friday s total sales for 2019 i.e.  1/18/2019 --> this is working 

    for friday of last year i.e. 1/19/2018 --> this is not working 

     

    Daily sales report.. Not week. 

     

    so how to filter for a particular date ?