Author Topic: Limiting / Filtering Calendar items  (Read 830 times)

trebor

  • Member
  • *
  • Posts: 57
Limiting / Filtering Calendar items
« on: April 12, 2016, 09:34:23 AM »
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

  • Member
  • *
  • Posts: 57
Re: Limiting / Filtering Calendar items
« Reply #1 on: April 13, 2016, 09:18:59 AM »
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