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.