Dates in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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)
 
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...
 
Back
Top