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
Date stored in short date format in the table.
03/01/2004
Print out as:
January 2004
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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.
=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
table.
Thanks