[V4Rb 2] Searching by date

[Claudius Sailer]

Am 17. Jun 2005 um 02:57 Uhr schrieb Charles Yeomans:

> The following SQL doesn't work (either with V4Rb or VStudio)  --
>
> SELECT recID, MatterPtr, Description, TimeWorked FROM TimeEntries  
> WHERE EntryDate='2005-06-16'
>
> but this one does --
> SELECT recID, MatterPtr, Description, TimeWorked FROM TimeEntries  
> WHERE EntryDate='6/16/2005'
>
> Is this a known problem?

try this

WHERE EntryDate=date'6/16/2005'

bye


Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 5.5.5/ Valentina 1.10.0 & 2.0.4
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]