Join a date interval to a date table
Hi, I need help with following problem and the picture below illustrates what I have in terms of tables and what I want to accomplish (but haven't so far). Our purchasing department want to s...
Forum Discussion
Thanks a lot for taking the time!
Two questions:
1. Should I join the storeprice table with the date table somehow (please see my picture).
2. I put in your formula (without doing any more joins than in my original post) but it does not give me what I want. Are you sure that your formula is supposed to work?
Best regards!
