Jump to content

This topic is 8587 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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?

Posted

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

Posted

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 ]

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.