Convert string to Date

[Valnurat]

I'm using the Active Directory UDF:

_AD_GetObjectAttribute($aUser[$i], 'whenCreated')

but I get the "date" like this 20100428063235.

Is there a built-in converter for this kind "date"?

[UEZ]

How should be the output format?

 

You can try something like this here:

#include <Date.au3>

$sDate = "20100428063235"

$sConvert = StringLeft($sDate,4) & "/" & StringMid($sDate, 5, 2) & "/" & StringMid($sDate, 7, 2) & " " & _ ;date
            StringMid($sDate, 9, 2) & ":" & StringMid($sDate, 11, 2) & ":" & StringRight($sDate, 2) ;time

ConsoleWrite(_DateTimeFormat($sConvert, 1) & @CRLF)

 

Edited March 23, 2016 by UEZ

[mikell]

Or a simple regex

$sDate = "20100428063235"
$res = StringRegExpReplace($sDate, '(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})', "$1/$2/$3 $4:$5:$6")
Msgbox(0,"", $res)

 

[Unc3nZureD]

There isn't a built-in, but as you can see:

20100428063235

Year Month Day Hour Minute Second

 

Now you can make exactly the same or similar functions as UEZ & mikell told you, or just use their functions

[Valnurat]

Global $sDate = _AD_GetObjectAttribute($aUser[$i], 'whenCreated')
            $sConvert = StringLeft($sDate,4) & "/" & StringMid($sDate, 5, 2) & "/" & StringMid($sDate, 7, 2) & " " & _ ;date
            StringMid($sDate, 9, 2) & ":" & StringMid($sDate, 11, 2) & ":" & StringRight($sDate, 2) ;time
            MsgBox($MB_SYSTEMMODAL, $aUser[$i], $sConvert)
            Global $sconDate = _DateTimeFormat($sConvert,1)
;           $sconDate = "2005/03/24"
            if _DateIsValid($sconDate) Then
                MsgBox($MB_SYSTEMMODAL, $aUser[$i], $sConvert)
            Else
                MsgBox($MB_SYSTEMMODAL, "Valid Date", "The specified date for: " & $aUser[$i] & " is invalid: " & $sConvert)
            EndIf

Your outcome looks ok, but when I try to validate it, it fails.

$res = StringRegExpReplace($sDate, '(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})', "$1/$2/$3 $4:$5:$6")

Your outcome looks ok, but when I try to validate it, it fails.

But if I do this:
$sConDate = "2005/03/24"

there is no problem.

[Unc3nZureD]

Then have a look at what is his regexp giving? What is the outcome? Is it matching the pattern which _DateIsValid acccepting?

[UEZ]

2 hours ago, Valnurat said:

I get the "date" like this 20100428063235.

1 hour ago, Valnurat said:

but when I try to validate it, it fails.

Well, what it the real output from _AD_GetObjectAttribute? I don't have a AD yet to test.

 

[mLipok]

Maybe this would be helpful:

 

 

 

[water]

Use function _AD_GetObjectProperty. Translates date/time to YYYY/MM/DD HH:MM:SS

[Valnurat]

On ‎22‎-‎03‎-‎2016 at 4:50 PM, water said:

Use function _AD_GetObjectProperty. Translates date/time to YYYY/MM/DD HH:MM:SS

Water is like a Ninja.

 

It worked thank you.

 

[water]

[nooneclose]

Really wish he posted his code because that is exactly what I'm looking for and I can not figure it out.