December 28, 200421 yr I need a calculation that I can use within a set field script step that will look at the current date and from that determine what the date on the Monday of that week is/was. Similarly I'll need calcs for each or the remaining four business days, but I'm assuming if someone can point me in the right direction for the Monday calculation, I can alter it to get the calcs for the rest of business week. I'm pretty sure that I've seen this calc before but I can't seem to locate it anywhere. Any help would be much appreciated. Thanks
December 28, 200421 yr This week's Sunday: dateX - DayofWeek(dateX) + 1 This week's Monday: dateX - DayofWeek(dateX) + 2 and so on..
Create an account or sign in to comment