FormatDateTime (Date, DateFormat) -Function:-The FormatDateTime function will formats dates and times. The output format is: MM/DD/YYYY

FormatDateTime (Date, DateFormat)

The FormatDateTime function will formats dates and times. The output format is: MM/DD/YYYY
This is one which we are using frequently.

Example:-

a=formatdatetime("06/May/84")
msgbox a

'OutPut is:-5/6/1984

FormatDateTime("15:34")

Output:
6/26/1943
3:34:00 PM

There is one optional argument.
DateFormat
The optional DateFormat argument must use the constant or value from the Date Format CONSTANTS.

Example:-

a=formatdatetime("06/May/84",1)
msgbox a
'OutPut is:-Sunday,May 6,1984