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