Date format

[PoojaKrishna]

Hai friends,

Please help

In my Data Base, the field date has MM/dd/yyyy format but I'm getting the date in my script from the database in dd/mm/yyyy format. How could I get this date in the same format as in the database(MM/dd/yyyy).

Pooja.

[weaponx]

;Convert DD/MM/YYYY to MM/DD/YYYY
$original = "30/04/1980"
$new = StringRegExpReplace($original, "\A(\d*)/(\d*)/(\d*)","$2/$1/$3")
MsgBox(0,"","Before: " & $original & @CRLF & "After: " & $new)

[PoojaKrishna]

Thanks Weaponx

The AutoIt always shows the date in the local format, so it is dd/MM/yyyy in my system.

So before changing the date format,I have to check the local format. How could I check that?

Pooja