Date relationships not working

Hey everyone, I'm having an issue with creating a relationship between my Date field in my Calendar table and the Date field in my data table. I created the relationship as I always have in the past, and ensured that the data types are both set to "Date" in the Query editor. It seemed to work, as selecting a year on my page level filteres filtered the weekly data in my data table. However, I went to spot check the data and noticed that when I create a simple table visual with the two fields "Start of Week" from Calendar table and "Schedule_Start_Date" from Data table, the dates from my Calendar table duplicate as if there is no relationship, though there clearly is since some of the dates are lininng up. I exported the data to excel to troubleshoot, and the dates in the two fields are an exact match. Any idea why this might be happening?