Display a "Date" or "Month" or "Year" in a report

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

Does anyone know how to set a control (on a report) to display only the
"Year" or "Month" or "Date".

If you set the control to " =date()" this will display 8/2/2000

I need this to display the date "2" only.

Thanks
 
The function "Date()" returns the date.

If you want to change how it looks, take a look at the Format property for
that control. You can use the Format property (or the Format() function) to
make it look like "2008" or "August" or "6".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top