date format conversion

L

linz fiske

can someone explain how to convert data cells from 6/15/04 to 06/15/2004?
i have set up an input mask 00/00/0000 but it only applies to new data. is
there a way to convert the existing data to that format?
 
O

Ofer

In the format property of the field select short date or write the format
mm/dd/yyyy
in the format property
 
R

Ricky Hicks MVP

Not sure I understand what you mean ...
A Date/Time value is stored as a numeric double ...
The date and time 08/18/2005 9:20 PM would be stored internally as ..
38582.8888888889
So the way it is formated is directly related to how it will be displayed ...

R. Hicks
 
Top