Simple Date Query

  • Thread starter Thread starter Joe Spenceley
  • Start date Start date
J

Joe Spenceley

Hi,

I have a field which is general date and contains dd//mm/yy hh:mm:ss.

I want to count number of records for each date.

e.g. something like

SELECT Count(Messages.MessageID) AS CountMessage, Messages.DateStamp
FROM Messages
GROUP BY Messages.DateStamp;

This groups by the time rather than the date. I've looked at using DatePart
to construct a query but that is looking rather clumsy. Is there a more
efficient way of doing this?

Cheers,
Joe
 
Joe said:
I have a field which is general date and contains dd//mm/yy hh:mm:ss.

I want to count number of records for each date.

e.g. something like

SELECT Count(Messages.MessageID) AS CountMessage, Messages.DateStamp
FROM Messages
GROUP BY Messages.DateStamp;

This groups by the time rather than the date. I've looked at using DatePart
to construct a query but that is looking rather clumsy.
Click to expand...


Try:

GROUP BY DateValue(DateStamp)
 
Back
Top