[V4Rb 2] Searching by date

[Ivan Smahin]

Hello Charles,

Friday, June 17, 2005, 3:57:29 AM, you wrote:

CY> The following SQL doesn't work (either with V4Rb or VStudio)  --

CY> SELECT recID, MatterPtr, Description, TimeWorked FROM TimeEntries WHERE
CY> EntryDate='2005-06-16'

CY> but this one does --
CY> SELECT recID, MatterPtr, Description, TimeWorked FROM TimeEntries WHERE
CY> EntryDate='6/16/2005'

CY> Is this a known problem?

Obviously db has MDY date format and '/' as date separator.
If you want to use another format you could do next:

mDB.DateFormat = EVDateFormat.kYMD
mDB.DateSep = '-'



-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua