Compare dates

[Valnurat]

I'm trying to compare to dates.

CurrentDate = 2016/03/29

SourceDate = 2016/01/10

local $sMonthsBetween = _DateDiff('M', @YEAR & "/" & $aDateSplit[2] & "/" & $aDateSplit[3], _NowCalcDate())

result:
2

Months between gives me "2" and that is ok

local $sDaysBetween = _DateDiff('D', @YEAR & "/" & $aDateSplit[2] & "/" & $aDateSplit[3], _NowCalcDate())

Result
79

Days between gives me "79" and that is not ok.

I would like the result was 19.

How can I do that?

[MichaelHB]

Like this?

local $sDaysBetween = _DateDiff('D', @YEAR & "/" & @MON & "/" & $aDateSplit[3], _NowCalcDate())

Result
19

 

[Valnurat]

2 minutes ago, MichaelHB said:

Like this?

local $sDaysBetween = _DateDiff('D', @YEAR & "/" & @MON & "/" & $aDateSplit[3], _NowCalcDate())

Result
19

 

Aha. Yes, that was of course an idea. Thank you.

[MichaelHB]

Glad to help.