[V4Rb 2] Searching by date

[Charles Yeomans]

On Jun 17, 2005, at 3:34 AM, Ivan Smahin wrote:

> 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 = '-'

Ah, I see.  Thanks.

--------------
Charles Yeomans