How do I write a rolling date query?

Christine Williams February 18, 2021

I need to write a query that will provide a rolling 30, 60 and 90 day look from current date.  I've tried using the now(90d) but must not know exactly how to write it because I'm getting an error "Function 'now' expected '0' arguments but received '1'."

1 answer

0 votes
C_ Derek Fields
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 18, 2021

don't use now(). just write "dueDate > 30d" 

Christine Williams February 18, 2021

thanks! That is helpful for items that are 90 days out.  I want to see items that are due in 30 days, 60 days then 90 days.  

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 18, 2021

Use 60d and 90d in the same way.

lenajeannette_smith February 8, 2022

Is there a way to do a rolling 90 day query; for example, JAN FEB MAR, FEB MAR APR, MAR APR MAY; realizing that some months will have >90 days?  Or will the > 30, >60 >90 work?  If so, can you provide an example of the query using year, 2021 ?

Suggest an answer

Log in or Sign up to answer