Group by using Date field

  • Thread starter Thread starter Mark R.
  • Start date Start date
M

Mark R.

Is there an expression I can use to group by using a Date
field that will group using only the Month and Year (not
the day)? Also can it be done using one field rather than
splitting them into two?

Thanks!
 
-----Original Message-----
Is there an expression I can use to group by using a Date
field that will group using only the Month and Year (not
the day)? Also can it be done using one field rather than
splitting them into two?

Thanks!
.
Here is how I do it. Create a field in the query with the
Click to expand...
following expression. CDate(Format(
![field
name], "mm/yyyy")) You will be able to group by that and
it will be in date format.
 
Back
Top