Last post May 02, 2013 10:31 AM by Prashant Kumar
May 02, 2013 10:17 AM|rspiet|LINK
I kept getting error messages on a user form when I was inserting dates into SQL-Server if the user typed a valid date that was out of the range of what SQL-Server considers a date. For instance, if the user typed 01/01/957 instead of 01/01/1957. I edited
the date field that the user typed in with the IsDate function, but the IsDate function considers 01/01/957 a valid date. But if I try to insert this date into a SQL-Server DateTime field, it returns an error since the date is out of range.
After realizing this, I added edits to check the date range too. I am curious though, is there any sort of build in function like IsSqlServerDate that checks if the date is a valid date in SQL-Server?
May 02, 2013 10:30 AM|oned_gk|LINK
May 02, 2013 10:31 AM|Prashant Kumar|LINK
T-sql has a function IsDate