CalasTyph0n

yep, this was exactly the issue. thank you very much.

Hi, you are correct in your assumption l’ll give it a try tomorrow. im based in the UK so write my dates as dd/MM/yyyy, inspecting the data in the table pre query has it in the above format so I just assumed that should work given the locale settings and the fact it is fine when run from sql studio 2018. thanks for…

Thank you for taking the time to respond and provide the level of input you did, much appreciated! I had totally forgotten that I had posted this. I've since resolved my query myself and got everything working without issue now.