Date Format

[Grant Dayton]

I want to have my report display a date format for example 11-05-09, i want
it to display as 2009-11 (YYYY-MM). Can this be done? I couldn't figure out
if I try and format this in the table or the report ot the query that
generates the report.

Thanks

 

[fredg]

I want to have my report display a date format for example 11-05-09, i want
it to display as 2009-11 (YYYY-MM). Can this be done? I couldn't figure out
if I try and format this in the table or the report ot the query that
generates the report.

Thanks

In the Report itself, set the control's Format property to:
yyyy-mm

To display the date value, for example, as 2009 November you would
use:
yyyy mmmm

This information is readily available in Access Help.
Format Property - Date/Time Data Type

 

[John W. Vinson]

I want to have my report display a date format for example 11-05-09, i want
it to display as 2009-11 (YYYY-MM). Can this be done? I couldn't figure out
if I try and format this in the table or the report ot the query that
generates the report.

Thanks

If it's stored in your table as a Date/Time field, simply set the Format
property of the textbox on the Report to

"yyyy-mm"

You can use the Format() function in the query to convert the date to a text
string, but it's more efficient to simply set the format on the report itself.