Good morning Scott
see the link - https://kb.tableau.com/articles/howto/showing-records-that-fall-within-a-period-of-time for a specific solution that you may need to modify to meet you needs
Or FAQ: Open & Close Dates - for a list of other possible solutions
The start/end date type of problem is more complex than it first appears - but if you follow the steps IN SEQUENCE you should get the result you want
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Good morning, and thank you for your input. Unfortunately the first link you supplied isn't working for the issue I'm trying to resolve. Things start to fall apart on Step 5 of the directions it laid out. I'll be spending the better part of today going through the massive list you supplied in your second link. Once I'm able to find the resolution, I'll post it here as well.
Apologies, I haven't read through carefully, nor followed the links,
so this suggestion may already be included by Jim or in his links.
It is, if possible for your datasource type, to join to an external
data scaffold of a single column of all dates of interest.
Sorry to add to the links, but here are a few more that
generally discuss such a join (not specific to your question,
would need to be modified):
Re: Seems like it should be basic (you can ignore the Prep part of it)
this was resolved by creating an external .TXT file with a Master Date list. I then duplicated the original data source and did a cross data base join to the two date fields to the Master Date