> to_days(2001-01-01)-to_days(order_date) <=365. joseph, what are you trying to do?
if you have order dates in 2001 or later, that expression will always be true, simply because to_days(2001-01-01) will be less than to_days(order_date) and so the result will be negative and therefore always less than 365 > The query is executed successfully, but hte five entries it should > catch are not printed out. Your advice is welcome. five entries? can we see your query? rudy ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
