On 3/3/07, Rick Praetzel <[EMAIL PROTECTED]> wrote: > 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".
I don't know why, but it isn't working here. I have also tried SELECT * FROM DataEntryTable WHERE de_EntryDate <> "". That produces the expected results (all my records since de_EntryDate is defined as not null and there were no errors importing the dates). So it appears that I'm using the correct table name and field name. As I mentioned, I have tested with a known valid date. Using it either as a string literal or as a date object SQLDate is not working. I'm stumped. _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
