I am having a similar problem. I would like to append a SQL table from an excel spreadsheet and come across a variety of errors. I have one field that is a date and another that holds time. When I added the modify time node to remove the time from the date - that error was resolved, but now I have an error with the time field that I haven’t been able to resolve.
“casetime” of type “Local Date Time” from input does not match type “time” in database at position 2
When I use String to Date/Dime:
ERROR String to Date/Time (legacy) 0:14 Execute failed: Maximum number of fails reached: 100
I have tried to use nodes; Modify Time, Modfiy time zone, Time Field Extractor, and Extract Time Window(Legacy) and no desired result.
Any help is greatly appreciated.