[SOLVED] Date format in flat file

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6077020376

October 10, 2014, 04:48 AM

Martin vK

[SOLVED] Date format in flat file

Hi,

I have a (delimited) flat file source file with dates in it that look like "2014-10-31", so YYMD with a '-' separator.
How do I best describe this in a master file?

Martin.

This message has been edited. Last edited by: Martin vK,

WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster

October 10, 2014, 05:05 AM

Alan B

    FIELDNAME=date, ALIAS=date, USAGE=YYMD, ACTUAL=A10,$

Alan.
WF 7.705/8.007