Hi Jason That's a Windows artefact, to do with an integer limit in the count of seconds back to about 1903.
To handle dates correctly I bounce my data through a database (in my case SQL Server 2005) from the incoming source data and read the database with FME. This is a case where FME for SSIS makes sense. Cheers Bruce. Bruce Harold Geographic Information Solutions www.gis.co.nz Ph. (64) (0) 9 537 3247 Mb. (+64) (0) 21 2995995 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Birch Sent: Friday, 3 November 2006 8:36 a.m. To: [email protected] Subject: RE: [fme] Re: Invalid year using DateFormatter I'd like to see improvements in date handling in FME overall. I've been working on a Cemetery application, and have to jump through tonnes of hoops because many of my dates are pre-1900. (at least, I think that's the point where FME's generally great date handling starts to break down) Jason ________________________________ From: [email protected] on behalf of n_antiform Sent: Thu 2006-11-02 10:08 AM To: [email protected] Subject: [fme] Re: Invalid year using DateFormatter Hi again, I have created a small sample fmw, which routes the data to a Visualizer. Using dates up to 20371231 works fine, and the output date field is added. But when using dates from 20380101 and up, no output date field appears. So this is not a SDE/Oracle problem. This fmw was created using FME2006GB and WindowsXP sp2. And yes, I was writing to a date field in Oracle. The sample fmw is uploaded to the Yahoo site. Regards, Kjetil S-T --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > Hi Kjetil, > Can you add a Visualizer transformer after the DateFormatter to show > the data at that point. I'm curious as to whether it is the > DateFormatter that is the problem, our SDE/Oracle writer or an > Oracle/OS problem. > > Everyone here (in support) is well and truly baffled by this. We'll > look into it and let you know what we find. I assume it is a date > field you are writing to? What is your Operating System? > > Mark > > Mark Ireland, Senior Product Specialist > Safe Software Inc. Surrey, BC, CANADA > [EMAIL PROTECTED] http://www.safe.com > Solutions for Spatial Data Translation, Distribution and Access > > > --- In [email protected], "n_antiform" <kjetilsv@> wrote: > > > > Hi, > > > > I am loading dates into an ArcSDE Geodatabase (9.1) in Oracle 10. > > Formatting and loading dates using the DateFormatter works fine, > > except a few dates which ends up having <null> value in Oracle. > > > > Input format for all dates are YYYYMMDD and the output date > > format in the DateFormatter is %Y%m%d. > > > > All the dates that are rejected are in the range of Year 2041 - 2046. > > > > FME Help states that: > > "Not all platforms can represent the years 38-70, so an error may > > result if these years are used." > > > > Does this mean that I can't import these dates? > > Seems weird... > > > > I am using FME 2006 GB/Windows XP sp2. > > > > > > Regards, > > Kjetil S-T > > Norway > > > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
