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.
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.
"date_of_birth>????#### AND date_of_birth<????####+2w"
because this structure cannot be represented in AQL.