One quirk about VBScript is that it doesn't include a particularly good format function, like the one included with Visual Basic. For instance, when you format dates, all you have to use is FormatDateTime, which has these four formats:
vbGeneralDate 0 Default – VBScript will show a date and/or time, using the short date and long time formats.
vbLongDate 1 Show the date in the long format defined in your Regional Settings applet
vbShortDate 2 Show the date in the short format defined in your Regional Settings applet
vbLongTime 3 Show the time in the long format defined in your Regional Settings applet
vbShortTime 4 Show the time in the short format defined in your Regional Settings applet
The problem with this is that you can't get a format like MM/DD/YYYY with any of these, by default. You can create your own formatting, however, as shown in this function.
Function Year2000Format(datInput)
Year2000Format = Month(datInput) & "/" _
& Day(datInput) & "/" _
& Year(datInput)
End Function
This will return June 19, 1970 as 6/19/1970, which shows four digits in the year properly. If you need a leading zero, check the length of the value returned from the Month and Day functions and prepend a zero if the length is one.