Forum Discussion
DateRange between two fields
Hi all, happy new year! I'm starting to work with this tool and I don't have a lot of knowledge about this. My inquiry is pretty simple, I have 2 fields in a database, let's call them as START_D...
Maybe some clarification as to what it is you are asking - when you say you would like to check how many amounts between 1/1 and 1/3, does that mean you would like the rum of amounts:
* for all rows where the open date falls in that range?
* for all rows where the closure date falls in that range?
* for all rows where both the open date and the closure date fall in that range?
* for all rows where either the open date or the closure date fall in that range?
Since you are picking a range, it is necessary to know how to compare that range to the rows you are intending to filter.
Thank you for your response tonysellars
The third option is correct. For all rows where both the open date and the closure date fall in that range
Thanks