Hi

Have just found out that my code returns incorrect results if the First day of the week matches today, in that it also returns yesterdays records.

Am looking into a solution.

Thanks

Brendan

Hi all

I have managed to come up with the below SQL code to return the correct values. If anyone can see a way of optimising the code, then that is...

Hi bdohmen

Thanks a lot for your help. Your reply was exactly what I needed and it now works a treat.

Brendan