Hi All
I am trying to add an inbox filter by date but I cant get the syntax right. I have a field (assessment_date) and I want to be able to filter the retrieved results to only include the last 3 years from the now date.
I am sure this is simple, but cant get it working.
Thanks in advance
Solved! Go to Solution.
Hi Chris,
Take a look at Inbox Filter by Date in Query Expression - the pattern is
requestDate BETWEEN CURRENT_TIMESTAMP - (# of days) AND CURRENT_TIMESTAMP
3 years ≈ 1096 (365*3 + 1 since a 3 year span likely includes a leap year; it includes one extra day in the year before a leap year):
requestDate BETWEEN CURRENT_TIMESTAMP - 1096 AND CURRENT_TIMESTAMP
Hi Chris,
Take a look at Inbox Filter by Date in Query Expression - the pattern is
requestDate BETWEEN CURRENT_TIMESTAMP - (# of days) AND CURRENT_TIMESTAMP
3 years ≈ 1096 (365*3 + 1 since a 3 year span likely includes a leap year; it includes one extra day in the year before a leap year):
requestDate BETWEEN CURRENT_TIMESTAMP - 1096 AND CURRENT_TIMESTAMP