How do I write a rolling date query?

Question

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'."

lenajeannette_smith · Answer

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 ?

Nic Brough -Adaptavist- · Answer

Use 60d and 90d in the same way.

Christine Williams_h6v6cx · Answer

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.