The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
Feb 20, 2020 08:17 AM
Hi, I’m tryin to do api-request with “filterByFormula”. I want to filter by date and to filter by range.
I tried something like that, but it doenst work (Gettin no records): AND((DATUM) >= “02-01-2020”, (DATUM) <= “02-31-2020”)
How do i have to implement this kind of filter?
Thanks for your help!
Feb 20, 2020 08:41 AM
Got it: AND(IS_AFTER((DATUM), "2020-01-31"), IS_BEFORE((DATUM), "2020-03-03"))
AND(IS_AFTER((DATUM), "2020-01-31"), IS_BEFORE((DATUM), "2020-03-03"))