outputDate = DateSerial(CType("20" & Left(InputDate,2),Integer),CType(Mid(InputDate,3,2),Integer),CType(Mid(InputDate,5,2),Integer))
Assuming all the dates are after 2000. Otherwise, you'll need logic for that too.
Dig deeper on .NET Development for SQL Server
Related Q&A from Greg Low
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...continue reading
Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.