The way I understood the use of the ?ldFirstDayOfCurrentMonth This could be a VFP Date or VFP DateTime variable and VFP (or the ODBC driver) converts it to the proper format the backend uses.
Tracy > -----Original Message----- > From: David Crooks > Sent: Wednesday, January 03, 2007 11:12 AM > > This is the Where clause: > Entrylog.tEntryTime >= ?ldFirstDayOfCurrentMonth > > So, if the tEntryTime is 02/19/2004 17:03:21 then it should > not be selected if I enter 12/01/2006 00:00:01 to be the > ldFirstDayOfCurrentMonth value. Right? Well, it is... > > David L. Crooks _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

