Jump to content
Sign in to follow this  

[SOLVED] How do I find every Monday within a date range in Autoit?

Recommended Posts

Is it possible to use Autoit to find every Monday within a date range? An example would be I want to find every Monday between 1/9/19 through 4/9/19. Then Autoit would give me all the dates on which Monday lands between those two dates. 

Sorry but I don't have any code so far. I was wondering if it was even possible. I read the help file and I didn't see a function that could do that. 

Edited by nooneclose

Share this post

Link to post
Share on other sites

Sure, shouldn't be too hard. Here is an example you can study/play with:

#include <date.au3>
$startjuldate = _DateToDayValue(2019,1,9)
$endjuldate = _DateToDayValue(2019,4,9)
Global $iYear, $iMonth, $iDay

For $x =  $startjuldate To $endjuldate
    _DayValueToDate ( $x, $iYear,$iMonth, $iDay )
    if _DateToDayOfWeek($iYear,$iMonth,$iDay) = 2 Then
        ConsoleWrite("Monday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)


SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
Live for the present,
Dream of the future,
Learn from the past.

Share this post

Link to post
Share on other sites

@Jos Thank you again, Jos the code you posted works great. I just have one more question would it be possible to do something like this:

; The starting date
    $startjuldate = _DateToDayValue($StartDate[1])  ;_DateToDayValue(2019,1,9) 
    ; The ending date
    $endjuldate = _DateToDayValue($EndDate[1])  ;_DateToDayValue(2019,4,9) 
    Global $iYear, $iMonth, $iDay

    For $Index = $startjuldate To $endjuldate
        _DayValueToDate ( $Index, $iYear, $iMonth, $iDay )
        ; Finds the day based on its numerical value (1 = Sunday)
        If _DateToDayOfWeek($iYear, $iMonth, $iDay) = 2 Then
            ConsoleWrite("Monday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)

 For this, to work I need the code to be able to read a value in from an array. Is it possible to give a start date and an end date from an array element? 

Is there a function or something that can do this? (I know these array elements won't work here because of the _DateToDayValue calls for more args)

Share this post

Link to post
Share on other sites

@Jos I was able to figure it out using string manipulation. Here is what I have come up with:

$DayIndex = 0

    While $DayIndex < $IndexRows

        ; Gets the Start date from the array
        $Temp = $StartDate[DayIndex]
        $TempStart = StringLeft($Temp, 8)
        $StartTempYear  = StringLeft($TempStart, 4)
        $StartTempMonth = StringMid($TempStart, 5, 2)
        $StartTempDay   = StringRight($TempStart, 2)

        ; Gets the End date from the array
        $Temp = $EndDate[DayIndex]
        $TempEnd = StringLeft($Temp, 8)
        $EndTempYear  = StringLeft($TempEnd, 4)
        $EndTempMonth = StringMid($TempEnd, 5, 2)
        $EndTempDay   = StringRight($TempEnd, 2)

        ; The starting date
        $startjuldate = _DateToDayValue($StartTempYear, $StartTempMonth, $StartTempDay)  ;_DateToDayValue(2019,1,9)
        ; The ending date
        $endjuldate = _DateToDayValue($EndTempYear, $EndTempMonth, $EndTempDay)          ;_DateToDayValue(2019,4,9)

        Global $iYear, $iMonth, $iDay

        For $Index = $startjuldate To $endjuldate
            _DayValueToDate ( $Index, $iYear, $iMonth, $iDay )
            ; Finds the day based on its numerical value (1 = Sunday)
            If _DateToDayOfWeek($iYear, $iMonth, $iDay) = 1 Then
                ConsoleWrite("Sunday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)
            ElseIf _DateToDayOfWeek($iYear, $iMonth, $iDay) = 2 Then
                ConsoleWrite("Monday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)
            ElseIf _DateToDayOfWeek($iYear, $iMonth, $iDay) = 3 Then
                ConsoleWrite("Tuesday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)
            ElseIf _DateToDayOfWeek($iYear, $iMonth, $iDay) = 4 Then
                ConsoleWrite("Wednesday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)
            ElseIf _DateToDayOfWeek($iYear, $iMonth, $iDay) = 5 Then
                ConsoleWrite("Thursday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)
            ElseIf _DateToDayOfWeek($iYear, $iMonth, $iDay) = 6 Then
                ConsoleWrite("Friday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)
            ElseIf _DateToDayOfWeek($iYear, $iMonth, $iDay) = 7 Then
                ConsoleWrite("Saturday " & $iMonth & "/" & $iDay & "/" & $iYear & @CRLF)

        $DayIndex += 1


There most likely is a better way and if there is please tell me:) anyway thanks again you were a huge help! 

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By MiKa666
      Hi all,
      I'm developing a tool for exploratively testing another software. For that I wanna cover all the GUI functionality from that software and verify everything works as intended. But now I've a problem which I couldnt solve so far.
      One thing that software I'm testing does, is to load up either a single picture or a series of pictures. Depending on how much pictures got loaded, further actions will be proceeded...
      This loaded pictures are schon within a ToolbarWindow and they're clickable. What I need to know is, how much pictures are in this ToolbarWindow...
      Can anybody provide me a tip on how to achive this?
      Would be amazing!!
    • By meety
      wingettext function can get the text content of the IE browser page, but the text content of the page cannot be obtained in the chrome browser? What should I do?
    • By DirtyJohny
      Hi everyone.Need rewrite this function how in еxample.
      #RequireAdmin #NoTrayIcon Opt("MustDeclareVars",1) Func _a() Local $sls=ObjGet("winmgmts:{impersonationLevel=impersonate," _ &"authenticationLevel=Pkt}!\\"& _ @ComputerName&'\root\wmi'),$lss=$sls.ExecQuery _ ('SELECT * FROM WmiMonitorID'), _ $lll,$sll,$sss="",$lsl,$lls,$i,$z For $z In $lss $lsl=$z.UserFriendlyName For $i=0 To Ubound($lsl)-1 if ($lsl[$i]) Then $lll&=Chr($lsl[$i]) Next $lls=$z.SerialNumberID For $i=0 To Ubound($lls)-1 if ($lls[$i]) Then $sll&=Chr($lls[$i]) Next $sss&="Model"&@TAB&@TAB&": "&$lll&@CR&"Serial Number"&@TAB&": "&$sll&@CR&@CR $lll="" $sll="" Next MsgBox(262144,'Monitors '&$lss.Count,$sss&" "&@CR) $lss=Null $sls=Null EndFunc _a() Example:
      Func _InfoPC() Local $ObjService = ObjGet('winmgmts:{impersonationLevel = impersonate}!\\' & @ComputerName & '\root\cimv2') Local $ObjMB = $ObjService.ExecQuery('SELECT * FROM Win32_BaseBoard', 'WQL', 0x30) If IsObj($ObjService) Then For $objItemMB In $ObjMB $sInfo &= @TAB & 'Motherboard: ...... ' & $objItemMB.Product & @CRLF I'm beginner in this sphere and need  you all speak easy and simply because i'm Russian.Thanks)
    • By Deshanur
      Am trying to automate injecting credential on the login form for all kind of Web application for IE. I know how to identify the form name by viewing the source code and using the method - _IEFormGetObjByName($ie, $form_Name).
      I would like to know how to identify or get the form object for the web app where there is no form name tag for example below, for the is I have used - _IEFormGetCollection($ie, 0) to get the form object.
      My Question is does it work for all kind of application "_IEFormGetCollection($ie, 0)" how to identify Index value? is it always 0? is there any better solution?
      The final solution am looking for is find out form object, get the username, password field and inject credential and submit the form.
      How to find out index value? for the forms which does not have form name field.
      $login_form = _IEFormGetCollection($ie, 0) $email_field = _IEFormElementGetObjByName($login_form, $form_UserName) $pass_field = _IEFormElementGetObjByName($login_form, $form_password) $login_button = _IEFormElementGetObjByName($login_form, $form_submitbutton) _IEFormElementSetValue($email_field, $CmdLine[2]) _IEFormElementSetValue($pass_field, $CmdLine[3]) ControlSend($hwnd, "", "[CLASS:Internet Explorer_Server; INSTANCE:1]","{Enter}") OR This works fine if the form has form name. $login_form = _IEFormGetObjByName($ie, $form_Name) $email_field = _IEFormElementGetObjByName($login_form, $form_UserName) $pass_field = _IEFormElementGetObjByName($login_form, $form_password) $login_button = _IEFormElementGetObjByName($login_form, $form_submitbutton) _IEFormElementSetValue($email_field, $CmdLine[2]) _IEFormElementSetValue($pass_field, $CmdLine[3]) ControlSend($hwnd, "", "[CLASS:Internet Explorer_Server; INSTANCE:1]","{Enter}")
    • By JuanFelipe
      Hello guys!
      I have a problem with a script, in the past I made a program and it worked perfect, I recently used it again and it already stands still in one step, the problem is a Javascript event that changed but now I cannot execute it.
      <td colspan="2" align="center"><input type="button" id="Buscar" name="Buscar" value="Buscar" onclick="javascript:enviarForma(document.obtenercasosPersonaPorDocumento,'0');" class="boton"></td>  
      Previously I used this code and it worked, but now it does nothing
      $botonconsulta = _IEGetObjByName($oIE,"Buscar") _IEAction($botonconsulta, 'click') _IELoadWait($oIE)  
      Now I have tried the following codes but none works.
      ;==================== 1 _IEHeadInsertEventScript($oIE, "document", "onclick", "javascript:enviarForma(document.obtenercasosPersonaPorDocumento,'0');") ControlClick("SUPER CELAC", "", "[CLASS:Internet Explorer_Server; INSTANCE:1]") _IELoadWait($oIE) ;==================== 2 $forma = $oIE.document.obtenercasosPersonaPorDocumento $oIE.Navigate("JavaScript:enviarForma("&$forma&",""0"");") _IELoadWait($oIE) ;==================== 3 $boton = _IEGetObjById($oIE, "Buscar") $boton.document.parentwindow.execScript("enviarForma(document.obtenercasosPersonaPorDocumento,'0');", "javascript") I hope you can guide me, because I think the error is in the parameters that the javascript function receives but I don't know how to send it, here I leave the first part of the JavaScript function.
      function enviarForma(frm,tipoForma){ var bExisteDatoConsulta = false; var bError=true; var mensajeError=""; switch (tipoForma) { //--Forma documento case "0": if (validar_campo_no_vacio_no_print(frm.numeroDocumento)) { if (!isNum(frm.numeroDocumento.value)) { bError = false; mensajeError += "El número de documento debe ser un valor numérico\n"; } bExisteDatoConsulta = true; } else { mensajeError += "Debe digitar un número de documento\n"; } break;  Thanks!
  • Create New...