I have implemented a single Master Calendar table with a Calendar Link table, since my data has multiple dates. I can't get the DATE key to properly join Master_Calendar and CalendarLink. For some date values it joins but the majority it does not. I have carefully formatted all dates the same way so I don't understand why it is not linking properly. If you look at my QVW file, I have a straight table that just subtracts one date from the other and even though they appear the same (for example, FIRST_REFERRAL_DATE and ADMIT_DATE both show as 12-04-2013) the comparison indicates they are in fact slightly different. In the source data these are in fact timestamps but I believe I have stripped off the time portion in my load script.
Anyway I am completely stuck - can anyone look at my QVW and offer advice?
