You have found the bug.... We came across this just the other week.
It is all to do with Juliann dates. Can't remember the exact detail but will try to find out and post. Cheers Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -----Original Message----- From: Timothy Snyder [mailto:[EMAIL PROTECTED] Sent: 09 June 2006 16:03 To: [email protected] Subject: Re: [U2] UniVerse Internal Date Blackout [EMAIL PROTECTED] wrote on 06/09/2006 10:16:08 AM: > >SELECT TESTFILE WITH DATE > 14000 > Bad data "14000" for conversion "D2/". Unconverted data used for > selection. > > 8 record(s) selected to SELECT list #0. > > > CLEARSELECT > > >SELECT TESTFILE WITH DATE > 14001 > > 0 record(s) selected to SELECT list #0. > > >SELECT TESTFILE WITH DATE > 14365 > > 0 record(s) selected to SELECT list #0. > > >SELECT TESTFILE WITH DATE > 14366 > Bad data "14366" for conversion "D2/". Unconverted data used for > selection. > > 2 record(s) selected to SELECT list #0. So why are you using internal date values against a date-formatted dictionary item?!? If (for whatever bizarre reason) you want to do that, just use a dict item that specifies a straight numeric value. For the record, this is looking at 14001 as year 14, Julian date 001. 14365 is Julian date 365 in year 14. 14366 is day 366 in year 14. Oh, wait, there was no day 366 in year 14 - bad data. Hey, there was no day zero (14000) either! Make it easier on the humans and unambiguous for the computers. Use external dates. Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
