Re: insert error after updating sql server

[Barry Galbraith]

Date functions allow "Date arithmetic", like "this month", "today + 30 days", "difference between 2 dates" etc. But you have to have your dates stored in a field of type DATE for the functions to work.

There are functions to allow a DATE (YYYY-MM-DD) to be displayed in any format, even american MM-DD-YYYY, but they have to be stored as type DATE.
There are functions to take a string representing a date, say, "Tue July 31 2018" and store it correctly in type DATE.

Well worth investigating, and using.

Good luck,
Barry.