Changing date format of a flat file using VB.NET
I am trying to copy a flat file into a table in SQL using DTS, but the flat file has been generated by an AS/400 system and the date is formatted like this (yymmdd=051206). At the time of conversion, I want it to be formatted into the datetime SQL datatype format. I am developing in VB.NET.
Using VB.NET, you can use the DateSerial function something like:
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.
This was first published in December 2005