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'."
don't use now(). just write "dueDate > 30d"
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use 60d and 90d in the same way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.