Returned Date Format

[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