Viewing only records for tomorrow's date

[Guest]

I am trying to query a list of service calls from my database for only
tomorrow's date.

The field I want to query is called: ApptDate

I have tried to query as follows: <date () which of course only returns
every call greater than today's date. How can I only get records dated for
the next day?

Thanks!
~Matt

 

[Duane Hookom]

<date() should return previous dates, not future dates. If there is no time
stored in the ApptDate field, you can use:
ApptDate = Date()+1
If ApptDate stores a time element, try:
DateValue(ApptDate) = Date()+1

 

[Guest]

Your solution worked, however I didn't have the ApptDate field set as a
date/time field in my table. So of course, it wasn't able to add 1 day to the
current date. Once I changed the field type, it worked perfectly.

Thanks for the help!