Date Format

  • Thread starter Thread starter Grant Dayton
  • Start date Start date
G

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
 
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
Click to expand...

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
 
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
Click to expand...

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