Simple Date Query

[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

 

[Marshall Barton]

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.

Try:

GROUP BY DateValue(DateStamp)