If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Format
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 |
#2
|
|||
|
|||
Date Format
On Thu, 5 Nov 2009 12:32:00 -0700, Grant Dayton wrote:
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 -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Date Format
On Thu, 5 Nov 2009 12:32:00 -0700, "Grant Dayton"
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|