colinr

Got it thanks.

I came up with timestamp(CURRENT_DATE()-1)+(14/24) Let me know if you have anything better!

Fantastic Reply! thank you for the walkthrough and that should do it! Will let you knowif I have any questions but looks somewhat straightforward!

Worked a treat. thanks!

Ended up using this to be the 'last Thursday' part. Not sure if ther is a more elegant way for it but it does the job. case when DAYOFWEEK(CURRENT_DATE())=1 then CURRENT_DATE()-3 when DAYOFWEEK(CURRENT_DATE())=2 then CURRENT_DATE()-4 when DAYOFWEEK(CURRENT_DATE())=3 then CURRENT_DATE()-5 when DAYOFWEEK(CURRENT_DATE())=4…

Nevermind. seemed to work just like this: CONCAT(CURRENT_DATE(),' 12:00:00') Did not need the string part to compare to a date column.

Many thanks!