Time Calculation Problem

[leegold]

Hi,

I can not get a time calculation to work. It's probably something simple I'm missing:

...

Case $msg = $settime
                $dt = GUICtrlRead (11)
                ;$tm = GUICtrlRead (12)
                $tm = "15:07:52"
                $dt = StringStripWS($dt, 3)
                $tm = StringStripWS($tm, 3)
                $dtrgex = StringRegExpReplace($dt, '(d{1,2})/(d{1,2})/(d{4})', '$3/$2/$1 ')

                ConsoleWrite("|" & $dtrgex & $tm & "|") ; future time

                $DateCalc = _DateDiff('s', _NowCalc(), $dtrgex & ' ' & $tm)

                ;$DateCalc = _DateDiff('s', _DateTimeFormat(_NowCalc(), 2) & ' ' & _DateTimeFormat(_NowCalc(), 5), $dtrgex & ' ' & $tm) ; this didn't work either...

                ConsoleWrite("DateCalc: " & $DateCalc & @LF)

 

I'm getting 0 for the date calculation. Obviously I'm doing something wrong. I would be grateful for help.

Console:

|2013/9/7 15:07:52|
DateCalc: 0

[Melba23]

leegold,

You have the wrong format for the date. You need YYYY/MM/DD - you are providing YYYY/M/D.

I would ensure the correct 0-padded format using StringFormat like this:

#include <Date.au3>

$dt = "2013/9/7"
$tm = "15:07:52"

$aSplit = StringSplit($dt, "/")
$dt_Format = StringFormat("%04d/%02d/%02d", $aSplit[1], $aSplit[2], $aSplit[3])

ConsoleWrite("|" & $dt_Format & $tm & "|" & @CRLF) ; future time

$DateCalc = _DateDiff('s', _NowCalc(), $dt_Format & ' ' & $tm)

ConsoleWrite("DateCalc: " & $DateCalc & @LF)

That works for me.  All clear?

M23

[leegold]

Yes, all clear. Superb. Thank you