When triggered customer queries are executed, the query is supplied a ‘querydate’ that can be used for the constraint date parameters.
For triggered email customer queries or auto tagging, the querydate will be yesterday’s date. Thus, if emails are being processed as part of Daily Maintenance on December 2nd, the querydate supplied to the query will be December 1st.
Customer Queries support relative dates. Relative dates can be based on ‘today’ for normal Customer Queries.
In the case of triggered queries, relative dates must be based on the querydate.
When using date parameters for a triggered customer query, you will want to use relative dates based on the querydate parameter. In the example below, the date range is the trailing month.
You can press the relative date builder when modify a date parameter to open the relative date builder to learn the expression syntax.
Some examples of relative dates:
● querydate = will be yesterday for an email trigger or daily auto-tagging rule
● querydate, -7 days = will be yesterday minus 7 days for an email trigger or daily auto-tagging rule
● querydate, -1 month = will be yesterday minus one month for an email trigger or daily auto-tagging rule