Conditional date add, Please help

G

GerryE

I have a form with a combo box [Quotestatus], and a subform [tblQuoteLog
subform] with [RequestedDate] field. I need help creating a code for the
after updated event of the [Quotestatus] field. When "LDS" is selected in
the [QuoteStatus] field, I want the [tblQuoteLog subform]![RequestedDate]
field to automatically fill in the current date + 5 more days. But if the
date falls on a Saturday or Sunday I need for the RequestedDate field to add
an additional 2 days. One more tricky part is that if the [QuoteStatus] is
updated after 11:45 a.m. the RequestedDate field needs to add one additional
day. Please help!
 
R

ruralguy via AccessMonster.com

That seems to be enough requirements. What part are you having problems with?
Have you searched for Business Days? Can you create a UDF
(UserDefinedFunction) in a standard module?
I have a form with a combo box [Quotestatus], and a subform [tblQuoteLog
subform] with [RequestedDate] field. I need help creating a code for the
after updated event of the [Quotestatus] field. When "LDS" is selected in
the [QuoteStatus] field, I want the [tblQuoteLog subform]![RequestedDate]
field to automatically fill in the current date + 5 more days. But if the
date falls on a Saturday or Sunday I need for the RequestedDate field to add
an additional 2 days. One more tricky part is that if the [QuoteStatus] is
updated after 11:45 a.m. the RequestedDate field needs to add one additional
day. Please help!
Click to expand...
 
Top