DateTime comparison Help

[CassidyHunt]

I am trying to create a script that runs everyday but before it runs it checks that it is not after 4:00 p.m. on the last day of the month. I can not seem to get past converting the string version of the date into a date then being able to make the comparison.

$sDate = _DateTimeFormat(@mon & "/" & _datedaysinmonth(@year,@mon) & "/" & @year & " " & "16:00:00",5)

if _NowCalc() < $sDate then

;do this

else

;don't do this

endif

All help will be greatly appreciated. Thank you

Cassidy

[PsaltyDS]

Compare with _DateDiff().

But your input to _DateTimeFormat() is formatted wrong, and I'm not sure what you're after with it. Should be "YYYY/MM/DD[ HH:MM:SS]" (see help file). You have "MM/DD/YYYY HH:MM:SS".

Maybe you want:

#include <Date.au3>

$sDate = @YEAR & "/" & @MON & "/" & _DateDaysInMonth(@YEAR,@MON) & " " & "16:00:00"
If _DateDiff("s", _NowCalc(), $sDate) > 1 then
    ConsoleWrite("do this" & @LF)
Else
    ConsoleWrite("don't do this" & @LF)
EndIf

Edit: Add demo.

Edited November 2, 2009 by PsaltyDS

[CassidyHunt]

Only question I have for that is what if it is the last day of the month at 15:59:00? Would that come up as 1 or would it be a decimal less than 1?

[PsaltyDS]

Only question I have for that is what if it is the last day of the month at 15:59:00? Would that come up as 1 or would it be a decimal less than 1?

Since the diff is in "s" = seconds, it would return 60. Now the way I put it, it might NOT run at 15:59:59. If that's an issue change the compare to > 0, or >= 1.

Edited November 2, 2009 by PsaltyDS

[picaxe]

#include <Date.au3>

If @MON + 1 = StringMid(_DateAdd("D", 1, _NowCalc()), 6, 2) And @HOUR < 16 Then
    ConsoleWrite("Today is last day of this month before 16:00hrs" & @LF)
    ; do something
EndIf

[GEOSoft]

#Include<date.au3>
$iMonDays = _DateDaysInMonth(@YEAR, @MON)
If @MDAY = $iMonDays AND @HOUR >= 16 Then Exit

[CassidyHunt]

An overwhelming response. Thank you everyone. I think I can build a great solution from here.

I really appreciate it.

Cassidy