Is it possible to filter a Date Field by a range of date?
I have tried this way but it’s not working
It’s taking absolute dates only instead of a range.
“IN” condition checks the set of items, not the range. If you need to check the date range, you’ll have to add two conditions with “>” and “<” operators. Another option that may be useful in some cases is to use the “In interval” operator that allows to check some special cases, e.g. “This month” condition, that will always work for the current month.
Thanks. Use of two conditions worked pretty well.