just the date from a datetime field in a query

  • Thread starter Thread starter charlie
  • Start date Start date
C

charlie

Hi Folks,
I have a datetime field that is output in a query, however I only want the
date part to be returned not the time as well. Can I do this as part of the
query and if so how?
Cheers
Charlie.
 
Create a Calculated Field / Column in your Query

DateOnly: DateValue([YourDateTime])

and use this Column rather than the original [YourDateTime].
 
perfect, thanks a million!
Charlie.


Van T. Dinh said:
Create a Calculated Field / Column in your Query

DateOnly: DateValue([YourDateTime])

and use this Column rather than the original [YourDateTime].

--
HTH
Van T. Dinh
MVP (Access)



charlie said:
Hi Folks,
I have a datetime field that is output in a query, however I only want the
date part to be returned not the time as well. Can I do this as part of the
query and if so how?
Cheers
Charlie.
Click to expand...
Click to expand...
 
Back
Top