This feature is for advanced users!

To create and test a filter in Outlook:

1.select the folder in Outlook, right click the column header->View settings->button "Filter"
2.Add fields with your criteria
3.Close Outlook Filter dialog
4.Test filter results in Outlook, repeat the steps to modify your filter

Copy the filter to GeniusConnect:

1.select the folder in Outlook, right click the column header->View settings->button "Filter"
2.Click the SQL Tab
3.Check "Edit these criteria directly..."
4.Copy the query
5.Open GeniusConnect config->Database Tab
6.Right Click the folder->Advanced->"Add/Edit Outlook Filter"

Enter: @SQL=here your query
Example:



If you are not using DASL filter you can enter the filter directly without "@SQL=" keyword.

Examples:

Today Outlook filter for Calendar items:

Calendar filter "this and last month":

examples:
https://www.msoutlook.info/question/276 
https://blogs.msdn.micro...ter-and-sql-dasl-syntax/ 


DASL Examples:
To use DASL query, use:@SQL=<query>
Example 1:
End date <= today + 10 days (in seconds)
Example 2:
Start date >= last month


GeniusConnect saves outlook filter in registry:

I have a question concerning the Filters for Outlook 2003, what type of language and / or variables are available for the filter?
Because I am trying to synchronize only the daily emails so I setup this rule "[ReceivedTime] >= ToDay" which works fine but it doesn't synchronize the emails recieved between 00:00:00 till about 7:00:00 something like that.

I just want to tell you that I find the problem.. it's a little bit currious but it works. If you change in "tools -> options -> option of the calendar " and set the time of the begining of the day at 00:00 the filter import all the mails of the day. 🙂

Outlook Filter and 2 way sync:
Make sure your SQL Filter is filtering same data as your Outlook Filter!

You can ignore this remark when syncing only from Outlook to DB.

Microsoft Outlook set of date values:

yesterday
today
tomorrow
last7days
next7days
lastweek
thisweek
nextweek
lastmonth
thismonth
nextmonth

Example:

Filters Outlook 2007:
http://msdn.microsoft.co.../library/office/cc513841 (v=office.12).aspx

Example mail filter:
only email received yesterday and today
only email received today

Example email subject filter:

@SQL=(%yesterday("urn:schemas:httpmail:datereceived")% OR %today("urn:schemas:httpmail:datereceived")%)