put 0 in short date

D

dlb1228

i have a date/time field and the date is 11/2/2006 i want it to be
11/02/2006 and if its 1/2/2006 i want it to be 01/02/2006
 
K

Kevin B

Set the format for the field on a form/report or in the table definition
using the following format code:

mm/dd/yyyy

For additional formatting options press F1 while in the Format field of the
properties window and select Date/Time as the format type to view.
 
J

John W. Vinson

i have a date/time field and the date is 11/2/2006 i want it to be
11/02/2006 and if its 1/2/2006 i want it to be 01/02/2006
Click to expand...

You can change how the computer-wide "Short Date" format works (in Excel,
Word, and any other Microsoft or most non-Microsoft applications) works by
opening Start... Control Panel... Regional and Language Operations and
changing the format there. Or (perhaps better because it only affects what you
want it to affect), don't use Short Date as the format; instead "roll your
own" by typing mm/dd/yyyy in the Format property.
 
Top