Thank you in advance for your time.
I have a date field that states information as such:
10/30/2006 10:00:00 AM
Every morning I am looking to pull today's appointments.
The following code works, but I have to change the dates every morning:
Between #10/30/2006 8:00:00 AM# And #10/30/2006 5:00:00 PM#
How can I use the same code wihtout having to change the date every moring?
I have a date field that states information as such:
10/30/2006 10:00:00 AM
Every morning I am looking to pull today's appointments.
The following code works, but I have to change the dates every morning:
Between #10/30/2006 8:00:00 AM# And #10/30/2006 5:00:00 PM#
How can I use the same code wihtout having to change the date every moring?