Returned Date Format

[mv8167]

I have the following code:

Code:

eDate = DateAdd("d",-1,Now())
eDate = FormatDateTime(eDate,2)

which returns the value 6/29/2011

but I need the zero in front of the six. I need 06/29/2011 returned.

Any ideas is this is possible?

thx for looking.

[rajpes]

Code:

eDate = DateAdd("d",-1,Date)

If len(month(eDate))=1 then
eDate=0&eDate
end if[hr]

[mv8167]

Rajpes,

Thx again...

Your solution is way easier then my final solution:

Code:

TodayDateMinusOne = DateAdd("d",-1,Now())
    eDate = FormatDateTime(TodayDateMinusOne, 2)
    'Call DateManipulate(eDate)  Insure date is MM/DD/YYYY format

    'Function DateManipulate(eDate)
    'Insure date is MM/DD/YYYY format
    Set MyDate = DotNetFactory.CreateInstance("System.DateTime")
    Set oDate = MyDate.Parse(eDate)
    DateManipulate = oDate.ToString("MM/dd/yyyy")
    eDate = DateManipulate
    'msgbox DateManipulate
    Set MyDate = Nothing
    'End Function

lol

[rajpes]

ya, you don't need to complicate so much, just use simple logic