You'll need to include dimDate in the query multiple times--once for each date. Each will have its own join for the specific date field you're dealing with.
If this assists in resolving your question, please mark my response as the 'correct answer'. This will help other users with similar questions. Thanks!
Thanks Ken, that answered what I needed to do going forward to setup the backend properly.