Ok.Sorry. Ignore.
(damn).
What I'm trying is to get the Thursday BEFORE the current Thursday comes along.
So for example today we have Wednesday. I don'[t want to get the Thursday of the this week, so, not tomorrow.
What I would have to get today is 03/24 to 03/30 . Tomorrow the correct get would actually by (after 23:59 Wednesday), 03/31 to 04/06 .
Thanks.
I'm thinking of vb-ing that as I can't mix anything on SQL.Don't know maybe I am missing something...