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.

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top