Simple Date convertion

[Rogue5099]

I need to convert mm/dd/yyyy to yyyy/mm/dd.

I've looked all through the Date.au3 and all of that converts the date from what I need.

Is there a simple StringFormat I can do or something?

[somdcomputerguy]

Use the StringSplit function, with the slash as the delimiter, then rearrange the resulting array elements.

Edited June 13, 2011 by somdcomputerguy

[smartee]

Try this:

$sDateYYYYMMDD = StringRegExpReplace($sDateMMDDYYYY, '(\d{2})/(\d{2})/(\d{4})', '$3/$1/$2')

[guinness]

smartee you got there before me

[Rogue5099]

Ok, I see the concept but its not working... I also looked stringregexpreplace with the following example. Neither of these put out the Output that it should?

Local $sInput = 'some text1 12/31/2009 01:02:03 some text2' & @CRLF & _
        'some text3 02/28/2009 11:22:33 some text4'
    Local $sOutput = StringRegExpReplace($sInput, '(\d{2})/(\d{2})/(\d{4})', ' $2.$1.$3 ')

This is what I am trying to convert:

$Date = GUICtrlCreateDate("", 80, 72, 186, 21, $DTS_SHORTDATEFORMAT)
$sDateMMDDYYYY = GUICtrlRead($Date)
$sDateYYYYMMDD = StringRegExpReplace($sDateMMDDYYYY, '(\d{2})/(\d{2})/(\d{4})', '$3/$1/$2')

I know that GUICtrlCreateDate is defaulted to yyyy/mm/dd. Reason I have it set to mm/dd/yyyy is for matching purposes with other docs. I need it in yyyy/mm/dd to do a DateDiff()

Edited June 14, 2011 by rogue5099

[smartee]

hi,

Regexp is a usable solution but in this case it is not needed. Try this:

#include <DateTimeConstants.au3>
#include <GUIConstantsEx.au3>
#include <WindowsConstants.au3>

$Form1 = GUICreate("Demo1", 266, 42)
$Date1 = GUICtrlCreateDate("2011/06/14 10:44:4", 8, 8, 121, 25, $WS_TABSTOP)
$Button1 = GUICtrlCreateButton("Check", 136, 8, 121, 25)
GUISetState(@SW_SHOW)

;Set the format of the DateTime control
GUICtrlSendMsg($Date1, 0x1032, 0, "yyyy/MM/dd")

While 1
    $nMsg = GUIGetMsg()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit
        Case $Button1
            MsgBox(64, "Demo1", GUICtrlRead($Date1))
    EndSwitch
WEnd

-smartee

[somdcomputerguy]

Does this work for you?

$datevar = StringSplit("mm/dd/yyyy", "/")
ConsoleWrite($datevar[3] & '/' & $datevar[1] & '/' & $datevar[2] & @LF)

[Rogue5099]

Does this work for you?

$datevar = StringSplit("mm/dd/yyyy", "/")
ConsoleWrite($datevar[3] & '/' & $datevar[1] & '/' & $datevar[2] & @LF)

This is exactly what I could't figure out, I was just having a brain fart!

To smartee: Your method works also except it changes the whole format of the Ctrl that I set previously. I just needed to move the year to the end, store it to a variable, and then use it for datediff to calculate time worked.

By the way thanks for all the input. Even though I using a simple stringsplit doesn't mean that I won't use the other information later thanks a lot!

[somdcomputerguy]

Glad it works out for you. Good luck with your project.