Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Date format in flat file
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Date format in flat file
 Login/Join
 
Platinum Member
posted
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 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 154 | Registered: March 29, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
    FIELDNAME=date, ALIAS=date, USAGE=YYMD, ACTUAL=A10,$


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Date format in flat file

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.