Converting short date to show mm/dd/yyyy

crabjoe · March 5th, 2007, 03:30 PM

Ive got a field set to shortdate and when you enter a date, it appears as 6/5/2007. How do I change this to show 06/05/2007? I can't figure out how this is done, but it's gotta be something stupid simple.

Thanks!

crabjoe · March 5th, 2007, 03:57 PM

Forget it guys, I figured it out. I just changed the format field from shortdate to mm/dd/yyyy.

crabjoe · March 5th, 2007, 04:03 PM

Ok, I'm back again... Now I'm trying to convert the date 06/05/2007 to a string, but when I do, I lose the leading zero again. Can anyone give me the correct syntext? str([DATE]) just doesn't work. :(

mmcdonal · March 6th, 2007, 09:02 AM

Are you losing the leading zero in the month and the day? Or just the month?

mmcdonal

martinrhague · March 7th, 2007, 03:46 AM

Have you tried using FORMAT.

For example

DIM strDate as String

strDate = Date

FORMAT(srtrDate,"mm/dd/yyyy")

This should provide you with all leading zero's