Dennis, As an aside, I never use date fields. I work mostly in MySQL, but also Valentina and REALSQL I do a tremendous amount of date calling for reservations and cash register transactions. I store all dates as strings: YYYYMMDD then deal with it in RB as a date object thru a method I store Timestamps as strings: YYYYMMDDHHMMSS
I had all kinds of headaches when trying to use date fields. Now I never have any problems. Comparing dates is particularly easy. Subtracting dates isn't as easy. I will keep an eye on your problem, though, because I am building myself a REAL db browser, editor, designer over the next few days... Rick Praetzel Desert Sand Software RB 2007R1 Dual 2.5 GHz G5, 3GB RAM, OSX 10.4.8 > 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>
