Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top