events between to date
events between to date
I have a DB with records that have a "EXPIRY" field.
How do I specify a criteria for a view that will return those records ending in the next seven days,
(Expiry == (zoho.currentdate + '0W:1D:0H:0M:0S') || Expiry == (zoho.currentdate + '1W:1D:0H:0M:0S'))
does not work
and the result would not return those already expired but only those expiring in the next 7 days
something like "between >= today and <= today+7"
Thank you
Alain D.
Montreal,Canada