I'm working on a VBScript -- thanks to BlueDevilFan's assistants several times before -- I'm trying to use the FormatDateTime Function to display the start date/time of a meeting -- in the following format:
11/18/2015 08:00 AM
Using the following line:
excSht.Cells(lngRow, 2) = (FormatDateTime(olkAppt.Start,2) &" "& FormatDateTime(olkAppt.Start,3))
I should be able to just use the default FormatDateTime function without any numbers (0), correct?
When I use the exact line above - just without the space, it displays the date/time in the correct format -- but without a space between the date and time.
excSht.Cells(lngRow, 2) = (FormatDateTime(olkAppt.Start,2) & FormatDateTime(olkAppt.Start,3))
As soon as I put the space in, it puts double times in, and without the AM/PM...
I've also tried the obvious:
excSht.Cells(lngRow, 2) = olkAppt.Start
-- but it doesn't provide the correct format -- ex 11/18/2015 08:00 AM
If it matters, this was used to create an Excel document - now being used to create a tab-delimited text file -- it doesn't seem to change any of the other functions...