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?

Perfect! Thanks!

Kuku

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

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 ]