Sounds like you have hit the problem where, depending on the UDT.OPTIONS 82 value, the system will evaluate to external format first. If you change the UDT.OPTIONS 82 value then you should find it will work.
The manual states that this should only happen with dates starting 10, 11 or 12... But worth a look... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 Jun 2006 15:16 To: [email protected] Subject: [U2] UniVerse Internal Date Blackout We just ran into a strange issue where LIST/SELECT cannot resolve an internal date - and it's for a block of one full year. >From May 1, 2006 (14001) through April 30, 2007 (14365), if you try to SELECT records in a file using the internal date value where the DICT item has a D2/ (or similar) conversion, it will simply report back 0 records selected even though records exist for the dates. The same SELECT using an internal date of 14000 or less, or 14366 or greater returns the correct records. Without the conversion code in the DICT, all the SELECTs work. A sample of what we're seeing is below. The first and last examples work fine, the middle examples fail. UniVerse release is 10.1.4 PICK Format on UNIX. Curious if anyone else is experiencing this 'blackout' year with these internal dates. Thanks! >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. Gary P. Canedy Database Analyst ProMutual Group (617) 757-6775 ----------------------------------------------------------- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
