Get records after specific date and time

[rooster]

I have a table with a date/time field that includes both date and time data, e.g. 11/09/2013 1:34:34 PM. I need to get records after a specific time and date.



I've tried this but doesn't seem to work:

SELECT * FROM Log 
WHERE EventDate > '11/09/2013 1:00:00 PM'

Any suggestions?

Thanks

[mrojas]

You'll probably need to enclose the date in #
WHERE EventDate > #11/09/2013 1:00:00 PM#

[rooster]

Thanks mrojas

i'm getting records with dates including:
9/11/12
9/1/13
9/9/13

Possibly part of the problem is mixing american dates (d/m/y vs. m/d/y), but this doesn't explain the 2012 date?

[mrojas]

Could you share the table, or tables in question?

[rooster]

See screen shots below of sql and records.

[June7]

If it really is a date/time type field, use # delimiter instead of apostrophe. If it's really a text field type then you have a problem and the filter/sort won't work the way you want. It will be an alpha sort/filter: "10" sorts before "9"

The left justification of the data makes me think it's really a text field.

[rooster]

Good pick June7, it was a text field.
I didn't create this DB, using an existing one. Never thought it would be text!

Changed the field to date, works fine now.

thanks