Plug-ins > Outlook Manipulator

Limiting / Filtering Calendar items

(1/1)

trebor:
Having some problems limiting what I pull from Outlook Calendars to a date range.

trying PCEM_FilterByFilterString( ), and putting in lots of different strings.

I have the PCEM_FilterByFilterString(""Start"= Main::gStart Date" ) right after the PCEM_OpenFolder ( Main::gFolder Calendar ).

the Microsoft references on "Restrictive Mode" is not an easy read. 

Any tips on how to limit the pulling of calendar items by date range would be much appreciated.

trebor:
Figured some things out I thought I would share.

#1 When querying using the PCEM_FilterByFilterString, set your criteria to a variable, then use that in the string as follows:

Set Variable [$TEMP_START_DATE;Value:Main::gStartDate)

PCEM_FilterByFilterString(  "[Start]  =   $TEMP_START_DATE")


In the previous step I set the $TEMP_START_DATE to a field that puts in a date and time stamp.

Now my problem is it is not pulling any calendar items.  It gets a success and reports a "0" but pulls nothing.  It is as if the "Start" is not the actual "Date" of the calendar items.  The date and time stamps are as follows:

Start : 4/1/2016 12:01:01 AM

End : 4/30/2016 12:59:59 PM

I have been poking around the Microsoft "Restrictive Method" pages and see only the Start and End to use for dates. 

Any help much appreciated.

Thanks
Rob

Navigation

[0] Message Index

Go to full version