how convert Date-Time to Date only

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I have two append queries that append data to a table. Then an Excel pivot
table is generated from this table. One of my two append query have data in
Date-Time format (1/12/1980 12:30AM), but I need to convert (not format) data
to just the date only (1/12/1980) to match other query.

What function I use in query to achieve this? Thanks
 
Back
Top