HTML <input type="date" />
elements store the value as an ISO8601 (YYYY-MM-DD) date string, but for us Americans it's very common for us to write the date as m/d/yy.
If you write the value as M/D/YY, that's a valid date but the value becomes 00YY-MM-DD
which is an invalid SQL Server date and causes errors when it shouldn't necessarilly.
Adding this directive to any <input type="date" />
should change the value to {CURRENT_FULL_YEAR}-MM-DD
automatically if you enter M/D/{LAST_TWO_DIGITS_OF_CURRENT_YEAR}
.
Disclaimer - This probably will not work well after the year 9999.