Inbox filter by Assessment Date

Question

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

JamesTedrick · Accepted Answer

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