All dates greater than "0002"? I suspect it's actually all dates > "1902". If you'd like, I could send you a bitmap that shows the impact of RBase date settings. I was involved in Y2K remediations for a Fortune 50 organization and used RBase to great advantage, as its DATE implementation seemed to be solid and consistent w/one type of correction, that is "date windowing" using a pivot-year. Anyway, it's all in the RBase "SET DATE %" parameters. Send me your e-mail address and I'll attach what I did to my e-mail.
HTH, Steve in Memphis ----- Original Message ----- From: "Dennis Fleming" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 9:22 AM Subject: Date Dilemma > Working with a customer yesterday who was selecting a report with all dates > greater than "8/1/02" and they got ALL dates. Reloaded indexes, and made > sure they were using the greater than sign, but unable to locate problem. > They sent me their data base and I found the Date was set to: > > Format: MM/DD/YY > Sequence: MMDDYYYY > > Not sure how this happened but the result is that you get all dates greater > than 8/1/0002 > > From the RBase Help for Set DATE: > >>>> > If the sequence is set to a four-digit year and the format is set to a > two-digit year, R:BASE stores the date you enter, such as 06/11/95, as a > four-digit year. As a result, if you use a WHERE clause to display rows > that have dates greater than 06/11/95, R:BASE returns all rows greater than > 06/11/0095. > > The DATE format can affect date functions. For best results, set the format > to the default MM/DD/YY and then use a date function. > >>>> > > It sounds a bit scary to ever have your format and sequence not to match. > Not sure when this would be a good idea. Hope to save someone else some > trouble shooting time. > > Dennis > ***** > > > > Dennis Fleming > IISCO > http://www.TheBestCMMS.com > Phone: 570 775-7593 > Fax: 570 775-9797 > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
