Formatted Date 1

[randy700]

Excel 2007

I have this code:

Dim dtMonthEnd as Date
dtMonthEnd = Format(#4/30/11#, "mm/dd/yy")

The result I'm getting is Month end = 4/30/11

I'm moving this to a mainframe file and need 04/30/11. The leading zero is important on the mainframe.

Anyone know how I can get it formatted as needed?



Randy

 

[strongm]

Dim dtMonthEnd as String

(but I'd advise you read up on dates and how they are stored and displayed so as to get an understanding on what is going on here)

 

[randy700]

Of course.
I knew I was missing something obvious.
Thanks, strongm.

Randy