thank you everyone for their help, GSquared solution did it for me.

I did try and getting a conversion error when converting a data type to int.

Trying to find where the issue is

Unfortunately it did not.

I think its my fault of not explainning myself properly.

I truly appreciate all the help.

Ill give it one more try.

I have a datawarehouse that loads once a...

that is correct. I am just looking to get two days sales...

Yestrerday Sales (becasue im reporting of a datawarehouse) and same time last yeear.

I do have a calendar table.

And it is down to the DAY grain.

To be more specific I am creating a view with all the fields I need including the...

I would like SALES today and SALES for same day last year.

On the same row