Non-standard Date Formats Follow
I'm working in an Automotive Manufacturing environment and they have their own way that they want the dates formatted.
I'm receiving an SQL Database date format (2011-08-17) that I need to convert to a non-standard date format (17AUG2011). The output date format must be "2-digit day (zero padded)", "3-char Abbreviated Month", and "4-digit Year" with no separators between them.
My data source is a database field which is not the current system date.
I'm guessing that VB Scripting will be required but haven't been able to come up with the proper output using standard VB Scripts.
Any help would be greatly appreciated.
Please sign in to leave a comment.