• From post 2

    There are always a million ways to do anything. It's quite possible that your idea is better, but this one works

    from post 12

    Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

    oops doesn't seem to work as claimed in post 2

    from post 13

    I don't encounter the problem when I run it on my workstation, so I don't really know how to debug it.

    no further comment other than than do not re-invent the wheel, the round version we have does a fairly good job.