• Not at all.

    The issue for me was that the account the SSAS agent was running as had a default language of 'English' in the database engine, so when it was getting the data from the view it must have been using the YMD date format.

    Changing the login on the database server to be 'British English' corrected this and the data was then as expected.

    I hope that helps.

    Thanks,

    Nic