Date conversion in report?

H

Heather

If in a table you have a date saved as 1/04/2004 is there
anyway on a report to have it convert to the following
format yy/mm/dd???
 
M

Marshall Barton

Heather said:
If in a table you have a date saved as 1/04/2004 is there
anyway on a report to have it convert to the following
format yy/mm/dd???
Click to expand...


A format does not affect the way a value is saved in a
table. Actually a Date/Time value is saved as a Double
floating point number. All you need to do is specify the
format you want to see in the text box's Format property.
You want to use the Format:

yy/mm/dd
 
Top