I guess I could have just done the translation in the database, even with a function call in the select statement for the MSSQL source. I'll remember that for next time. Hmm. Maybe I did look at that, but the particular date format I wanted didn't have a secret code number? I can't remember, but it rings a bell. Jason
________________________________ From: [email protected] on behalf of Bruce Harold Sent: Thu 2006-11-02 11:53 AM To: [email protected] Subject: RE: [fme] Re: Invalid year using DateFormatter 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. 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/
<<winmail.dat>>
