format date with leading zeroes

J

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
 
T

Tom Lake

Jim Burke in Novi said:
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,
Click to expand...

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
 

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

Leading zeroes dropped in combination box 4
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Cocatenate not showing leading zeros MS Excel 2003 6
Changing mm/dd/yyyy To yyyymmdd 5
leading zeroes in text field 1
trim leading zeroes / change data type 2
leading zeroes on report date 3
Exporting Leading Zeroes to .txt file 2

Top