Selecting dates and the BETWEEN operator

[Ruslan Zasukhin]

on 2/28/04 9:07 PM, Gary Edge at valentina at panamind.com wrote:

> Can someone show me an example of using the BETWEEN operator to select
> all records from a table with the value of a datefield in say next
> month? I'm trying to give a user the option to select date ranges (eg.
> 'Next Week', 'Next Month','In two weeks', etc).

Hi Gary,

1) you can use BaseObject method changing formula on the fly.

   let methodFldMonth has formula month(fldDate)

Then you can do

    WHERE methodFldMonth = 3


2) it is possible to use LIKE pattern

        WHERE fldData LIKE '03/../2004'         // MDY format


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