Hmm 14001 through 14365 are a valid julian dates (14001 = 1 Jan 2014) So it is reading these as external dates in your selection. 14000 is not a valid julian date, so it is reading it as internal.
Just why are you trying to force selection using an internal date when you have a date conversion? Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 09 June 2006 15:16 > To: u2-users@listserver.u2ug.org > 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 > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
