Hi,
Trying to create a query from a 'start date' field, which brings records back listed 30 days back from the current date. I thought the syntax was 'now-30', but it apparently is not.
Date()-30 brings back records that are exactly 30 days old, but I need all records in the past 30 days.
any help is greatly appreciated!
Trying to create a query from a 'start date' field, which brings records back listed 30 days back from the current date. I thought the syntax was 'now-30', but it apparently is not.
Date()-30 brings back records that are exactly 30 days old, but I need all records in the past 30 days.
any help is greatly appreciated!