[SOLVED] Convert unformulated time String to a formatted string

[nooneclose]

I need help turning this string "20180913221626" into a formatted time string.

I need to go from this: 20180913221626

to this: 09/13/2018 10:16 PM

I do not always know what the date will be so I can not just use a variable I need to actually convert/format. 

I did see an older post in the forms that was basically the same question only the other guy did not post the working code and I can not figure out how to use _AD_GetObjectProperties properly to get what I want. 

As always any help would be appreciated. 

Here is the code I use to find the date, but it always gives me the unformatted version. 

;retrieve the items object
$oItem = $oOutlook.Session.GetItemFromID($aItems[1][0], Default)
$oItem.GetInspector

$eSentOn        = $oItem.SentOn                                         ; When was the email sent?
MsgBox("", "Sent On of the email", $eSentOn)

;*******************************************************************************
; Formats the date and time from the email
;*******************************************************************************
;Local $fDatenTime = _DateTimeFormat($eSentOn, 1)
;MsgBox("", "Formatted email time", $fDatenTime)

 $aProperties = _AD_GetObjectProperties($eSentOn)
_ArrayDisplay($aProperties, "Did the conversion work?")

 

Edited November 7, 2018 by nooneclose

[iamtheky]

#include<date.au3>

$str = "20180913221626"

msgbox(0, '' , _DateTimeFormat(stringleft($str , 4) & "/" & stringmid($str , 5 , 2) & "/" & stringmid($str , 7 ,  2) & " " & stringmid($str , 9 ,2) & ":" & stringmid($str , 11 ,2) & ":" & stringmid($str , 13) , 0))

 

[BrewManNH]

Use this UDF, and this format for the conversion, should work.

#include <MsgBoxConstants.au3>

#include "DTC.au3"

Global $sIn_Date, $sOut_Date

; Basic format
$sIn_Date =  "20180913221626"
$sOut_Date = _Date_Time_Convert($sIn_Date, "yyyyMMddHHmm", "MM/dd/yyyy at h:mm TT") ; <<<<<<<<<<<<<
MsgBox($MB_SYSTEMMODAL, "DTC Conversion", $sIn_Date & @CRLF & $sOut_Date)

 

[nooneclose]

thank you for the suggestions I will try them as soon as I can and get back with the results in the next few hours. 

[nooneclose]

Thank you both very much for the timely responses. Here is the code I used and it worked like a charm thank you very much! @BrewManNH and @iamtheky 

;*******************************************************************************
; Formats the date and time from the email
;*******************************************************************************
$fDateNTime = _Date_Time_Convert($eSentOn, "yyyyMMddHHmm", "MM/dd/yyyy at h:mm TT")
MsgBox($MB_SYSTEMMODAL, "DTC Conversion", $eSentOn & @CRLF & $fDateNTime)