Sign in to follow this  
Followers 0
CassidyHunt

DateTime comparison Help

7 posts in this topic

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

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by PsaltyDS

Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

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 by PsaltyDS

Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

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


George

Question about decompiling code? Read the decompiling FAQ and don't bother posting the question in the forums.

Be sure to read and follow the forum rules. -AKA the AutoIt Reading and Comprehension Skills test.***

The PCRE (Regular Expression) ToolKit for AutoIT - (Updated Oct 20, 2011 ver:3.0.1.13) - Please update your current version before filing any bug reports. The installer now includes both 32 and 64 bit versions. No change in version number.

Visit my Blog .. currently not active but it will soon be resplendent with news and views. Also please remove any links you may have to my website. it is soon to be closed and replaced with something else.

"Old age and treachery will always overcome youth and skill!"

Share this post


Link to post
Share on other sites

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

I really appreciate it.

Cassidy

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0