left join and dates

[rido1421]

Hi All

I have done a left join in my script im joining a table with Dates and Budgets to a table with

Budgets and a few other dimensions

after the join i have more than one date for each date... is it because of the left join?

how can I fix this?

[MarcoWedel]

You're welcome.

If this expression works for you, then maybe

DayName(Num#(Date)) as Date

will also return correct results.

Hope this helps

Regards

Marco