SQL Expression string Date incorrect

[mdahlen]

I am converting a string to a date field in an SQL expression and get the error 'failed to retrieve data from database - not a valid date'. The date entered was 10/50/2011. How can I determine if a string date is valid before I execute the rest of the SQL expression?

 

[Turkbear]

Hi,
10/50/2011 is not a valid date in any format..Was this a typo?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mdahlen]

yes---it was entered incorrectly by the user --it is a freee text field. I would like to eliminate these ridiculous dates before executing the rest of the SQL expression

 

[Turkbear]

Hi,
Unsolicited adfvice follows
Free text fields are not usually a good idea when allowing access to a database since a clever user could use SQL Injection methods
(

http://msdn.microsoft.com/en-us/library/ms161953.aspx

)
to manipulate the database data without DBA knowledge or permission.
End of advice

You could set a text mask on the field and or build in some check for validity before passing it to the expression.





To Paraphrase:"The Help you get is proportional to the Help you give.."