G
GLHEC-BLS
I have created a macro that schedules an appointment for a follow up based on
the current date and time. The follow up has to be scheduled for the next day
at 8 a.m. I'm not sure about the best way to do that. I can only get it to
except a specific date and time and not a variable date (one dat from the
current date) and a specific time. Here is what I have that schedules a
follow up one day from the current date two hours ahead.
olAppt.Start = Now() + (1#) + (2# / 24#)
But if it is Thursday then I need it to schedule it one day from the current
date at 8 a.m. I've tried something that looks like this, and slight
variations, but it doesn't work. The only part that doesn't work is the
#8:00:00# AM part.
If Weekday(dteNextDate) = 5 Then
olAppt.Start = Now() + (1#) & #8:00:00 AM#
Any suggestions? Is it even possible?
the current date and time. The follow up has to be scheduled for the next day
at 8 a.m. I'm not sure about the best way to do that. I can only get it to
except a specific date and time and not a variable date (one dat from the
current date) and a specific time. Here is what I have that schedules a
follow up one day from the current date two hours ahead.
olAppt.Start = Now() + (1#) + (2# / 24#)
But if it is Thursday then I need it to schedule it one day from the current
date at 8 a.m. I've tried something that looks like this, and slight
variations, but it doesn't work. The only part that doesn't work is the
#8:00:00# AM part.
If Weekday(dteNextDate) = 5 Then
olAppt.Start = Now() + (1#) & #8:00:00 AM#
Any suggestions? Is it even possible?