_DateTimeSplit strips leading 0

[Cyri 0]

Why does _DateTimeSplit() strip off the leading 0 on the month and day? Almost all the other date functions use dd and mm. Why not the split?

Edited January 5, 2010 by Cyri

[Jos 1,497]

Why does _DateTimeSplit() strip off the leading 0 on the month and day? Almost all the other date functions use dd and mm. Why not the split?

This is because this UDF is designed to calculate with the date and time values.

Jos

[Cyri 0]

This is because this UDF is designed to calculate with the date and time values.

Jos

I just wasn't expecting it is all. If I pass in 05 for the month I would expect the result to be 05 and not 5. I just looked at the function in Date.au3 and I see now why it doesn't. By the way, what's the easiest way to pad with a 0 in that case? Check the length?

_DateTimeSplit("2007/05/07", $aDate, $aTime)
If StringLen($aDate[2]) < 2 Then
    $aDate[2] = "0" & $aDate[2]
EndIf
If StringLen($aDate[3]) < 2 Then
    $aDate[3] = "0" & $aDate[3]
EndIf

[Jos 1,497]

Something like:

$mm = StringRight("0" & $mm,2)

[Cyri 0]

Something like:

$mm = StringRight("0" & $mm,2)

Thanks again Jos.