Dennis, this works for me: select * from newtable where newfield = '2007-03-03'
Rick Praetzel Desert Sand Software RB 2007R1 Dual 2.5 GHz G5, 5GB RAM, OSX 10.4.8 > Yes. I've tried it with single and double quotes. I've tried it with a > SQL date as a string literal. Nothing works. If I specify a date, I > get 0 records when I use a known good date. > > I can see that the dates are stored in the table in SQL date format by > selecting the table contents with no conditions (SELECT * FROM > de_DataEntryTable) and showing every field's stringvalue. So I'm > confused as to why I can't select on a date using the following: > SELECT * FROM DataEntryTable WHERE de_EntryDate = "2002-10-28". _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
