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

[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

 

[Jeff Boyce]

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

 

[Douglas J. Steele]

Or the DatePart function, or the Year, Day, Month functions....