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???


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format 1
Date Format Code 2
Report Date Formatting 4
Number of Days? 4
convert date 1
date filter 1
Display of a text field yy/mm/dd as mm/dd/yy in a report header 4
Date format 3

Back
Top