Outlook-EX Calendar Search by date

[Efo74]

Has anyone already had this problem? I'm trying to export the outlook calendar in ICS format, but I would like to narrow the search by date to the end of April. it doesn't work, no appointment returns. If I don't restrict by date it returns all the calendar. Can anyone help me ?

#include <OutlookTools.au3>
#include <array.au3>

Global $oOutlook = _OL_Open()
Global $aFolder = _OL_FolderAccess($oOutlook, "", $olFolderCalendar)
; Export all appointments with subject "" as ICS files
Global $aAppointments = _OL_ItemFind($oOutlook, $aFolder[1], $olAppointment, "[Start]='2020-04-01 00:00' And [End]='2020-04-30 23:59'", "Location", "ProgAutoit", "EntryID", "", 1)
If @error Then MsgBox(48, "", "Error finding an appointment. @error = " & @error & ", @extended: " & @extended)
Global $iTimer = TimerInit()
Global $iItemCount = _OLT_Export($oOutlook, $aAppointments, $iOLT_ExportTypeICS, @ScriptDir & "\Export\", "", False, "", $iOLT_DebugConsole)
if @error then MsgBox(48, "", "Error exporting items. @error = " & @error & ", @extended: " & @extended)
MsgBox(0, "_OLT_Export", $iItemCount & " appointments exported as ICS." & @CRLF & "Time: " & Stringformat("%.2f seconds", TimerDiff($iTimer)/1000))
Exit

 

[water]

Can you please try the following date/time format: YYYY/MM/DD HH:MM

Edited April 3, 2020 by water

[water]

If you want to retrieve all appointments that start and end in April you need to modify the query:

"[Start]>='2020-04-01 00:00' And [End]<='2020-04-30 23:59'"

[Efo74]

oops .. Thank you .. it works now 

[water]