Dates in Query

E

EA

I have a table with a date field called [Date Reported]. I have a query
where I would like to roll up all the dates by period and month. All entries
in May 2006 should all be returned as "5/1/2006", regardless of what date in
May it was in.

Thanks!!!
 
F

fredg

I have a table with a date field called [Date Reported]. I have a query
where I would like to roll up all the dates by period and month. All entries
in May 2006 should all be returned as "5/1/2006", regardless of what date in
May it was in.

Thanks!!!
Click to expand...

Period: Format([ADate],"m/\1/yyyy")

or..

Period: DateSerial(Year([ADate]),Month([ADate]),1)
 
E

EA

PERFECT!!! That is exactly what I wanted. THANKS!!!!!!!

fredg said:
I have a table with a date field called [Date Reported]. I have a query
where I would like to roll up all the dates by period and month. All entries
in May 2006 should all be returned as "5/1/2006", regardless of what date in
May it was in.

Thanks!!!
Click to expand...

Period: Format([ADate],"m/\1/yyyy")

or..

Period: DateSerial(Year([ADate]),Month([ADate]),1)
Click to expand...
 
Top