Relative date criteria in classic queries and their equivalent in new queries.
In classic queries, you can build relative date criteria using the format below:[Event Date] equals [Current Date]+5 [Event Date] equals [Current Date]-5
However, new queries use a different approach, using "is within" and "is exactly" operators.
Examples: Event Date is within the last 5 days/weeks/months Event Date is not within the last 5 days/weeks/months Event Date is within the next 5 days/weeks/months Event Date is not within the next 5 days/weeks/months Event Date is exactly 5 days ago/away Event Date is not exactly 5 days ago/away
For example if you want to translate classic query criteria to new query criteria:Classic Query: [Event Date] equals [Current Date]+5
New query: Event Date is exactly 5 days away
To properly retrieve contacts meeting this criteria a 'minus 1' has to be applied to the [Current Date] value in the query as shown:
Here the expression'- 1' was used after the value [Current Date] since dates here are looked at numerically.
The OR operator is used to separate the criteria for today and yesterday.
Comments
0 comments
Please sign in to leave a comment.