datalink Posted December 28, 2004 Posted December 28, 2004 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
comment Posted December 28, 2004 Posted December 28, 2004 This week's Sunday: dateX - DayofWeek(dateX) + 1 This week's Monday: dateX - DayofWeek(dateX) + 2 and so on..
datalink Posted December 29, 2004 Author Posted December 29, 2004 That's great. Works perfectly. Thanks.
Recommended Posts
This topic is 7339 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now