2 of 2 people found this helpful
Do you have a row in your data for every date between [Start Date] and [End Date]? If not, it sounds like you will need to join in a date table that does have a row for each date. If you do already have that, then you can do this with three filters. Call the field with the date for each row [Date]:
Filter 1 on calculated field [Start Date Filter] : [Date] >= [Start Date] set to TRUE
Filter 2 on calculated field [End Date Filter] : [Date] <= [End Date] set to TRUE
Filter 3 on [Date], selecting "Range of Dates". If you want this to appear as a list, make sure the pill in your filters is set to "Discrete" (blue).
Yeah, I don't have a row for every date that falls between the Start date and End Date. I am pursuing the workaround of joining a date table.
Thanks for your reply.