SQL DateTime format not recognized

This is the same exact problem I am having @Jon on ticket Fails on automated execution but works manually

@skalg when you run the flow manual from the execution window NOT the full automated does it work? or do you still get an error