Date conversion in report?

  • Thread starter Thread starter Heather
  • Start date Start date
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???
 
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
 
Back
Top