Queries with date fields

[Ruslan Zasukhin]

on 7/3/03 0:04, Claudius Sailer at Claudius at sailer-online.de wrote:

>> 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.

Correct.

You need at first create BaseObject method with formula:

            year(birthdate)

Then use this BaseObject method in your query.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------