searching for date only in datetime field

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Feb 16 18:22:50 CST 2005


On 2/16/05 1:39 PM, "Ralf Sander" <ralf at end-if.de> wrote:

> Hi Ruslan,
> 
> so, if I want to search for the  21/05/2004 it has to be:
> 
> WHERE fld > '21/05/2004 00:00:00' AND fld < '22/05/2004 00:00:00'
> 
> ?

Hi Ralf,

No, this is not good.

* well, it is possible to use BaseObject method
    
    mFld of type DATE with formula "fld"

So this method will have type DATE and extract only date part


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




More information about the Valentina mailing list