Date Time Question

  • Thread starter Thread starter ggonella
  • Start date Start date
If the purpose of the query is to provide data for a report, don't. Let the
report's sorting and grouping options do it. You can group by hours, days,
weeks, months, etc., there.

If you need it for some other reason, use the Fix function to strip out the
time part. Something like:

JustTheDate: Fix([YourDateField])

Of course this will just leave you with a number like 37330. To make it look
like a date again, you can use format or the CDate function.

JustTheDate: Format(Fix([YourDateField]),"Short Date")
 
Hi,
How do I group by date in a query if the Date and Time is combined?

James
Click to expand...

Put a calculated field in the query defined as

JustTheDate: DateValue([datetimefield])

and group by it.

John W. Vinson[MVP]
 
Thanks to both of you, it works and I can export the queries to Excel.
James
John said:
Hi,
How do I group by date in a query if the Date and Time is combined?

James
Click to expand...

Put a calculated field in the query defined as

JustTheDate: DateValue([datetimefield])

and group by it.

John W. Vinson[MVP]
Click to expand...
 
Back
Top