spragueg Posted September 4, 2001 Posted September 4, 2001 You can check the day of the week using a case statement. You could script this and insert this calculation upon submission or use it as a calculation. seven_bus_days_later= Case(dayof week(date_submitted) = 1, date_submitted +9, dayof week(date_submitted) = 2, date_submitted +9, dayof week(date_submitted) = 3, date_submitted +9, dayof week(date_submitted) = 4, date_submitted +11, dayof week(date_submitted) = 5, date_submitted +11, dayof week(date_submitted) = 6, date_submitted +11, dayof week(date_submitted) = 7, date_submitted +10, "" ) Does that help?
Kukuberra Posted September 5, 2001 Posted September 5, 2001 I need to get a projected end date for projects that are done by off-site vendors. I need one field that is a date 7 days in advance of the submital date but which will not count the weekends. Help please? Kuku
spragueg Posted September 5, 2001 Author Posted September 5, 2001 You can check the day of the week using a case statement. You could script this and insert this calculation upon submission or use it as a calculation. seven_bus_days_before= Case(dayof week(date_submit) = 1, date_submit -10, dayof week(date_submit) = 2, date_submit -11, dayof week(date_submit) = 3, date_submit -11, dayof week(date_submit) = 4, date_submit -9, dayof week(date_submit) = 5, date_submit -9, dayof week(date_submit) = 6, date_submit -9, dayof week(date_submit) = 7, date_submit -10, "" ) Does that help? [ September 04, 2001: Message edited by: spragueg ] [ September 04, 2001: Message edited by: spragueg ] [ September 04, 2001: Message edited by: spragueg ]
Recommended Posts
This topic is 8587 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