Hi - Access 16,  SMSS 18.5, SQLserver 2019 running on Windows 10.

It would seem as though this error, whole it is an error, is not preventing me using the server. I've been able to restore databases and use them. ...

Thank you.

I agree that it is a mess - but 2005 and one of the 2008s were installed as part of application installs - they wouldn't let me add the...

A good way is to see how you would answer this manually. For example - what would be the answer if you started at 00:01 and ended at 23:59?...

What is the code that you are using? If we see the approach you are taking, then maybe we can help you adjust it. If we give our...

Thank you for your support. All I have to do now is implement it 🙂

Thanks for the thought. I'm in the UK and so, hopefully, it would recognise the dd-mm-yyyy as well as yyyy-mm-dd.

I have tried the dd-mm-yyyy hh:mm:ss.nnn - but this didn't...

I've finally managed a long way around the problem. I created the table with a text field and a datetime field. I imported the data into the text...