Using Wildcards in Date Fields

Using wildcards for defining conditions on date fields.

When using wildcards for defining conditions on date fields use the Aurea CRM format YYYYMMDD (e.g. "????0523").

You can also define filters and queries for the current day, month or year. In this case, use the format $YYYYMMDD. Possible placeholders are # for the current date or ? for any date.

Note: You can use literal character values of ‘*‘ and ‘?’ using the escape sequences ‘\*’ and ‘\?’.

Examples

To get the current day and month regardless of year, use $????####. For Example - This filter can be used to determine all persons whose birthday is today. The filter $????##?? could be used to find everyone whose birthday is in the current month.

You can also add or subtract values like you can for $curDay: Define $????####+2w to find people whose birthday is in 2 weeks.

Note: It is also possible to perform wildcard searches like "date_of_birth>????#### AND date_of_birth<????####+2w" because this structure cannot be represented in AQL.