Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Previous Week Start and End Date

Hi I am trying to get previous week item counts, I was able to get the counts however having difficulty to capture previous week start date and previous week end date(week start from Sunday). I am trying with below expression but both returning current week start and end dates. Please advise. 

Last Week Start Date = Today()-Weekday(Today()-1)+1

Last week End Date =  Today()-Weekday(Today()-1)+7

I am expecting the result 4/25/2021 - 5/1/2021

Appreciate for help.

 

Need Help
  • richbenmintz's avatar
    richbenmintz
    5 years ago

    Hi Anonymous,

    Try the following

    Last Week Start Date = (Today()-WEEKDAY(TODAY())+1)-7

Last Week End Date = (Today()-WEEKDAY(TODAY())+1)-1

     

     

    Thanks,

  • sayaliredij's avatar
    sayaliredij
    5 years ago

    Hi You can check the following formula

     

    FirstDayOfLastWeek =
    var daynum = TODAY()
    RETURN
    daynum - (6 + WEEKDAY(daynum) )
     
    LastDayOfLastWeek =
    var daynum = TODAY()
    RETURN
    daynum - WEEKDAY(daynum)
     
    Regards,
    Sayali
    If this post helps, then please consider Accept it as the solution to help others find it more quickly.

3 Replies

  • richbenmintz's avatar
    richbenmintz
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    Hi Anonymous,

    Try the following

    Last Week Start Date = (Today()-WEEKDAY(TODAY())+1)-7

Last Week End Date = (Today()-WEEKDAY(TODAY())+1)-1

     

     

    Thanks,

    • TAMOREIRA's avatar
      TAMOREIRA
      Frequent Visitor
      1 year ago

      This is exactly what I needed and the missing parathensis from the original post is still tripping me. As in, why does the extra parathensis return the start of the week? 

  • sayaliredij's avatar
    sayaliredij
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi You can check the following formula

     

    FirstDayOfLastWeek =
    var daynum = TODAY()
    RETURN
    daynum - (6 + WEEKDAY(daynum) )
     
    LastDayOfLastWeek =
    var daynum = TODAY()
    RETURN
    daynum - WEEKDAY(daynum)
     
    Regards,
    Sayali
    If this post helps, then please consider Accept it as the solution to help others find it more quickly.