Date

M

Michael Kaendera

I have a query that pulls up records by date entered. The date is stored in
the date/time format. Is there a function or a way of changing the date
simply date without the time.
The data is captured through a barcode reader into the database as a
date/time field.I checked the barcode reader to see if it can capture the
date without the time. Now when I run my query it does not return any values.
 
M

MJatAflac

You can use the Date Value function. It will strip out the time and give you
just a pure date. The syntax is DateValue(somedate).

Mike Joyce
 
Top