_FTP_ListToArrayEx date problems

[lucamad]

Hi guys

I've a nagging problem with an FTP function for getting file modification datetime info.

My code:

$sess = _FTP_Open("session")
$conn = _FTP_Connect($sess, "ftp.mydomain.com", "myusername", "mypassword")
_FTP_DirSetCurrent($conn, "/doc")
$result = _FTP_ListToArrayEx($conn, 2, 0, 1)
_FTP_Close($sess)

_ArrayDisplay($result)

I need specific date format (required by _dateDiff() function): "YYYY/MM/DD[ HH:MM:SS]".

But the _FTP_ListToArrayEx return other date and time format!

According to AutoIt Help file, if we write:

$result = _FTP_ListToArrayEx($conn, 2, 0, 1)

the function date format should be "YYYY/MM/DD", but it return date in the format "YYYY/DD/MM" instead!

What's wrong?

THXX

[guinness]

Why not use a Function to Convert the Date e.g.

ConsoleWrite(_ConvertDate("2011/26/02") & @CRLF)

Func _ConvertDate($iDate) ; YYYY/DD/MM >> YYYY/MM/DD
    Return StringRegExpReplace($iDate, "\A(\d*)/(\d*)/(\d*)", "$1/$3/$2")
EndFunc   ;==>_ConvertDate

Edited February 26, 2011 by guinness

[lucamad]

Why not use a Function to Convert the Date e.g.

ConsoleWrite(_ConvertDate("2011/26/02") & @CRLF)

Func _ConvertDate($iDate) ; YYYY/DD/MM >> YYYY/MM/DD
    Return StringRegExpReplace($iDate, "\A(\d*)/(\d*)/(\d*)", "$1/$3/$2")
EndFunc   ;==>_ConvertDate

Your func works fine!

Do you know why _FTP_ListToArrayEx func doesn't work properly? At least, I should know if is a MY (random) problem, or if is an AutoIt one.

I can run this script in other pc / ftp servers, and use your conversion func, only if the issue is with AutoIt and it is always present.

To you how _FTP_ListToArrayEx works with dates?

Thanks!

[ProgAndy]

The date is directly created with _Date_Time_FileTimeToStr, wich should return the format "YYYY/MM/DD hh:mm:ss" by default or "MM/DD/YYYY hh:mm:ss" as an alternative. So I don't know whats going wrong.

Edit: Oh, its an error in _Date_Time_FileTimeToStr, the array indices are not correct. It should be this:

Func _Date_Time_FileTimeToStr(ByRef $tFileTime, $bFmt = 0)
    Local $aDate = _Date_Time_FileTimeToArray($tFileTime)
    If @error Then Return SetError(@error, @extended, "")

    If $bFmt Then
        Return StringFormat("%04d/%02d/%02d %02d:%02d:%02d", $aDate[2], $aDate[0], $aDate[1], $aDate[3], $aDate[4], $aDate[5])
    Else
        Return StringFormat("%02d/%02d/%04d %02d:%02d:%02d", $aDate[0], $aDate[1], $aDate[2], $aDate[3], $aDate[4], $aDate[5])
    EndIf
EndFunc   ;==>_Date_Time_FileTimeToStr

Edit: There is already a bug listed here: #1509

Edited February 27, 2011 by ProgAndy

[lucamad]

The date is directly created with _Date_Time_FileTimeToStr, wich should return the format "YYYY/MM/DD hh:mm:ss" by default or "MM/DD/YYYY hh:mm:ss" as an alternative. So I don't know whats going wrong.

Edit: Oh, its an error in _Date_Time_FileTimeToStr, the array indices are not correct. It should be this:

Func _Date_Time_FileTimeToStr(ByRef $tFileTime, $bFmt = 0)
    Local $aDate = _Date_Time_FileTimeToArray($tFileTime)
    If @error Then Return SetError(@error, @extended, "")

    If $bFmt Then
        Return StringFormat("%04d/%02d/%02d %02d:%02d:%02d", $aDate[2], $aDate[0], $aDate[1], $aDate[3], $aDate[4], $aDate[5])
    Else
        Return StringFormat("%02d/%02d/%04d %02d:%02d:%02d", $aDate[0], $aDate[1], $aDate[2], $aDate[3], $aDate[4], $aDate[5])
    EndIf
EndFunc   ;==>_Date_Time_FileTimeToStr

Edit: There is already a bug listed here: #1509

Good, many thx!!