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.

Note: The OR operator is used to separate the criteria for today and yesterday.