And maybe for the task on hand the code 12 would be correct for ISO "yymmdd" format:

DECLARE @YYMMDD DATETIME
SET @YYMMDD='2020-09-23 00:00:00.000' /* converts literal string to DATETIME...

Adding to the questions rather than the solutions:
Reading the caveats on the Access Database Engine install (link in Lowell's post above): it is NOT supposed to replace the JET...

Thanks for this tutorial, it was very helpful for my ETL project. I put instances of the task in at various places, it did work great. Now finally, I get...