I receive a CSV file from another company and take that data and upload it to my company's MS Access 2010 database. The upload and everything works fine, but when I try to run a query on the Date of Service I can never get the Now() or the Date() queries to generate any results. The format for the date field is:
m/d/yyyy h:nn
This is what automatically generated when I imported the data and I cannot change it through design view. I am guessing I could run an update query to change this, but was wondering if the format would be the reason I cannot get either the Now() or Date() queries to work.
Ultimately, I wanted to create a simple query that generated the next day schedule: Now()+1
Any help would be appreciated.