It's simply because 14001 through 14365 will resolve in the D2 conversion. That is a bad programming practice to use a DICT item with D2 and force internal format data for the compare. Just to be clear, this is not a problem with the system as all, this is just someone using the system incorrectly. If you are selecting on a DICT item that has a conversion, you NEED to select using converted values!! If you need to select both ways, just create another DICT item without the conversion code, ie. A DATE.INTERNAL dict item...
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, June 09, 2006 10:16 AM 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
