I am importing a list of events from excel into access. My excel data has a column with dates and times, formatted as: Custom: mm/dd/yy hh:mm AM/PM. When imported in access, it is formatted as General Date: mm/dd/yy hh:mm:ss AM/PM.
I have a query that pull up events with today's date, from the above mentioned field.
My problem: If does pull up today's date BUT ONLY if the time has occured yet. In other words, if the field reads 2/5/2016 12:00 PM, and I run the query at 8:00 am, that record of data does not show up. If I run the query after 12:00 pm, it does.
I have the field criteria set up as: Between Date() And Date()-9 (I also want it to pull 9 days prior). I have also tried Between Today() And Date()-9, and Between Date()-.25 And Date()-9.
Nothing works.
I as suspecting it has to do with how it was formatted in excel. But, I really don't want to do my export all over again.
Any help is greatly appreciated.
Thanks!