Error 242 SQLState: 22007

Casting a form date or datetime from a client (ie a browser) to a string variable & then splitting to a server side date / datetime variable.

There is a mismatch between the web server OS date and datetime settings, versus the running values. ie. Mismatch between EU and US settings. Resolved by setting both in sync.