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/
