Forum Discussion
DateRange between two fields
Thank yo so much for your replies guys! v-sihou-msft powerbirino3 BetterCallFrank
I think I was not enough clear with my example. The table structure I have is the following:
Order ID: int PK
Open Date: date
Closure Date: date
Amount: int
What I'd like to filter is with these 2 date fields. F.e. I'd like to check how many amounts did we get between open date 1/1 and closure date 1/3.
Thank you again!
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