format date with leading zeroes

[Jim Burke in Novi]

How do I use the Format statement to force leading zeroes on a date? I tried
Format(myDate,"MM/DD/YYYY") but this doesn't give me the leading zeroes. Any
help is appreciated.

Thanks,

Jim B

 

[Douglas J. Steele]

It should. Exactly what are you doing?

 

[Tom Lake]

How do I use the Format statement to force leading zeroes on a date? I tried
Format(myDate,"MM/DD/YYYY") but this doesn't give me the leading zeroes. Any
help is appreciated.

Thanks,

One way is to set the date format in your International settings in Control Panel's
Date/Time icon
In Vista it's in the Clock, Language and Region settings, Regional and Language
Options,
Change the date, time or number format.

I like that method since all my programs will be consistent.

Tom Lake

 

[Linq Adams via AccessMonster.com]

In Design View for the form, select the textbox holding the date, then goto
Properties - Format and in the Format Property enter

mm/dd/yyyy

 

[Jim Burke in Novi]

Whoops, my mistake. I screwed up - it is working. Sorry about that.