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 tr...
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.
richbenmintz's avatar
richbenmintz
Resident 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?