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]

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

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[John W. Vinson]

On Thu, 5 Nov 2009 12:32:00 -0700, "Grant Dayton" <dayt...@hotmail.com>
wrote:

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.
--

John W. Vinson [MVP]