Queries with date fields

[Claudius Sailer]

Hi,

Am Mittwoch, 02.07.03, um 22:56 Uhr (Europe/Berlin) schrieb Jacques 
Chanliau:

> I am a new user of Valentina and of course of this list, but I did not 
> found
> a response to my problem in the archives:
>
> Why a query like
> "SELECT * from xxxx where year(birthdate) = 1987"
> Don't work, birthdate being a vdate field (I use REALbasic)

IMHO functions are only supported in database-fields not in queries. 
Only SUM, MAX, MIN is at the moment supported.

You have to use something like this

SELECt *
FROm xxx
WHERE birthday BETWEEN ('01/01/1987' AND '12/31/1987')  //Valentina 
1.9.8b

I think this should work, but please play and test this with viSQL a 
really great Tool for testing SQL-Codes.

bye


Claudius

-- 
G4/733 QS / MacOS X 10.2.6de / RB 4.5.3de or 5.1de / Valentina 1.9.7