|
-----Original Message----- From: boothm@ibm.net <boothm@ibm.net> >Jon's reply of "If date <>*loval" was the answer. That worked just fine. You hit right on the nubbin of the problem John. The default date in an l-date field is 0001-01-01 which of course is well outside the 1940-2039 window. > >I still am unsure what happens though if a date is outside the 1940-2039 window, but not *loval. I still don't know how to test for that situation. Untested notion off the top of my head (but I'm sure it will work :): If you want to see if a date is before 1940-01-01, put a comparison date field in your program, initialize it to that value, and just do a compare. I'll bet you can extrapolate this for greater than 2030-12-31, right? --- Dave Shaw, General Nutrition, Greenville, SC (just down the road from BMW - Bubba Makes Wheels :) The opinions expressed may not be my employer's unless I'm sufficiently persuasive... +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.