Send based on Time.

[Henley12]

I have an interesting scenario here (at least, interesting to me). I have a maintenance work orders database that will send an email to the engineers when a person fills in an Access form and clicks "Send email". The database currently sends the email to the engineer selected as well as a night pager. The engineers want to know if it can be altered to send based on time of day. For example, between the hours of 7:00 AM and 3:00 PM, send the email to the engineer and the night pager. After 3:00 PM until 7:00 AM the next day, send only to the night pager. Also, on weekends, beginning at 3:00 PM on Friday until 7:00 AM on Monday, send only to the night pager. Any ideas would be greatly appreciated. I believe I can handle the time issue, but I'm not quite sure how to handle the weekend issue. Thanks.

 

[pbaldy]

Check out the WeekDay function, which will tell you what day of the week it is.

 

[Henley12]

By jove, I think you've got it! Thanks.

 

[pbaldy]

No problem. Just saw a license plate from AR today at lunch. They were a long way from home!