Extracting month from date and display/print in text

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
 
A

Allen Browne

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
 
R

Rick B

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

HKComputer

That's what I needed. And yes, my field is set as Date/Time in the
table.

Thanks
 
Top