Extracting month from date and display/print in text

  • Thread starter Thread starter HKComputer
  • Start date Start date
H

HKComputer

How can I do the following:

Date stored in short date format in the table.

03/01/2004

Print out as:

January 2004
 
Internally, Access stores the date as a number, and the formatting is only
applied at display time.

You can therefore just set the Format property of the text box on your
report to:
mmmm yyyy
 
Use the format property, or the format command in an unbound text box.

=Format([YourDateField], "MMMM YYYY")



Note: If this is indeed a Date/Time field in your table, then the date is
NOT stored in short date format in the table. The date is stored as a
number that represents the date and time.
 
Back
Top