StupidSTUPID dates conversion question

[Guest]

What is the VBA code to convert a date in this format (1/3/2006) to this
format (1/3/06)? I feel incredibly stupid asking this: is there a repository
I can view in Access that can give me a list of these common conversion codes?

 

[Douglas J. Steele]

You don't convert dates that way.

Dates in Access are stored as 8 byte floating point numbers, where the
integer portion represents the date as the number of days relative to 30
Dec, 1899, and the decimal portion represents the time as a fraction of a
day.

What you're trying to do is change how the date is formatted: its
presentation.

If this is a text box on a form or report, can set its Format property to
m/d/yy. You could also use the Format function: Format(MyDateField,
"m/d/yy")