topic Re: Query on a Date Field with LIKE in Data Management Questions

Query on a Date Field with LIKE

JoeBorgione — Mon, 03 Dec 2012 16:55:45 GMT

I've exported a table from a SQL Server database into a personal geodatabase. I need to query by a data field and can't quite figure out what I need to do when using a 'like' statement.

The date field in question looks like this:

10/6/2011 7:08:19 PM

There are thousands of records that have 10/6/2011 as the date. So I tried:

[date_field] like #10/6/2011 *# etc, but I'm told the syntax is wrong.

I can use the equals statement like this:

[date_field] = #10/6/2011 7:08:19 PM#

and it's good to go. But of course that's just one record...

Any suggestions are appreciated.

Re: Query on a Date Field with LIKE

JakeSkinner — Mon, 03 Dec 2012 18:55:04 GMT

Hi Joe,

You could use the following expression:

[DATE_FIELD] > #10-06-2011 00:00:00# AND [DATE_FIELD] < #10-06-2011 23:59:59#

This will select all the records with a date of 10/6/2011.

Re: Query on a Date Field with LIKE

JoeBorgione — Mon, 03 Dec 2012 19:49:26 GMT

Thanks Jake; I did something similar and it worked out....