Date/Time Conversion 1

[Swi]

Hi,

I have the following date format. I would like to split out the date (which would be easy enough but how would I translate the time to HH:MM AM/PM?

Ex. - 2023-07-06T14:34:21-04:00

I would like to have:

DateToUse = YYYY-MM-DD
TimeToUse = HH:MM AM/PM

Thanks.

Swi

 

[jlcca]

This is using VBScript, which can easily be translated to VB6

arrDateTime = Split("2023-07-06T14:34:21-04:00","T")
WScript.Echo arrDateTime(0)
WScript.Echo arrDateTime(1)
arrTime = Split(arrDateTime(1),"-")
WScript.Echo arrTime(0)
WScript.Echo FormatDateTime(arrTime(0), vbShortTime)
WScript.Echo FormatDateTime(arrTime(0), vbLongTime)

returns

2023-07-06
14:34:21-04:00
14:34:21
14:34
2:34:21 PM

Joe

 

[Swi]

Thanks.

T14:34:21-04:00

I didn't know if I needed to do anything with the -04:00

Thanks again.

Swi