Format date in yyyy-mm-dd hh:mm:ss

[Nikesh]

Is there any function available to convert or format date in following format.

yyyy-mm-dd hh:mm:ss

[Andreik]

Is there any function available to convert or format date in following format.

yyyy-mm-dd hh:mm:ss

From what format?

[Nikesh]

From what format?

From 'mm/dd/yyyy hh:mm:ss' to 'yyyy-mm-dd hh:mm:ss'

[Andreik]

From 'mm/dd/yyyy hh:mm:ss' to 'yyyy-mm-dd hh:mm:ss'

An example but maybe you can do this with Date fucntions.

;~ 'mm/dd/yyyy hh:mm:ss' to 'yyyy-mm-dd hh:mm:ss'

$TEST = "06/04/2009 01:45:37"

Func FormatDate($DATE)
    $SPLIT = StringSplit($DATE," ")
    $YYYY = StringRight($SPLIT[1],4)
    $MM = StringLeft($SPLIT[1],2)
    $DD = StringMid($SPLIT[1],4,2)
    Return $YYYY & "-" & $MM & "-" & $DD & " " & $SPLIT[2]
EndFunc

MsgBox(0,"",FormatDate($TEST))

[Nikesh]

An example but maybe you can do this with Date fucntions.

;~ 'mm/dd/yyyy hh:mm:ss' to 'yyyy-mm-dd hh:mm:ss'

$TEST = "06/04/2009 01:45:37"

Func FormatDate($DATE)
    $SPLIT = StringSplit($DATE," ")
    $YYYY = StringRight($SPLIT[1],4)
    $MM = StringLeft($SPLIT[1],2)
    $DD = StringMid($SPLIT[1],4,2)
    Return $YYYY & "-" & $MM & "-" & $DD & " " & $SPLIT[2]
EndFunc

MsgBox(0,"",FormatDate($TEST))

This works for me.

Many thanks to you

[weaponx]

;Convert MM/DD/YYYY HH:MM:SS to YYYY/MM/DD HH:MM:SS
 $original = "04/30/1980 01:02:03"
 $new = StringRegExpReplace($original, "\A(\d*)/(\d*)/(\d*)","$3/$1/$2")

[GreenCan]

Look at this topic,

the udf DateCalc.au3 will help you with this

http://www.autoitscript.com/forum/index.ph...ost&p=96173

GreenCan