Get date only from DateTime. 1

[ChrisCalvert]

Hello:

I have what I thought would be a simple problem, but I cannot find an answer so far. I am trying to run a query on a table with a datetime field. I just want my resulting table to have the date (for purposes of counting).
Does anyone know how this can be done. I thought Date([Timestamp]) would be it, but that requires three variables.

 

[dhookom]

Use DateValue([YourExpression]) to return only the date part of a datetime value.

Duane
MS Access MVP