Forum Discussion
convert date to integer
Date joins are supported - even preferred over SK joins. What do you meant "not honouring". Are you saying the join won't even complete, or it completes but then the behaviour is unpredictable? Is there any time key information in one of the columns? Is it possible you have rouge records in one of your date columns that are not dates? Are both date columns from the same locale?
i have two datetime columns. i want to join on just Date. i covert each column from DatetTime do just date. i go to join on date, and the model does NOT parse - it cannot find a record match. i the background, SSAS is STILL storing the datetime info, even though i changed the datetime data type to date. so it does not drop the time info on the data point.
SO the model does not parse - so you have to make another tpye of key....
