SQL date range syntax

[Ruslan Zasukhin]

on 2/12/03 10:31 AM, Tim Davis at timdavis at amug.org wrote:

Hi Tim,

>   Could you give me a quick clue on how to do an SQL date range in
> Valentina? (I'm using the latest version of V4RB.) I would like to use
> something like the following but its not working. (Below "MyDate" is a
> Valentina Date field.) Are there other ways as well?
> 
> Select * From MyTable Where MyDate < '1/1/03'
> or
> Select * From MyTable Where MyDate >= '1/1/03' And MyDate < '2/1/03'

You write correctly.

Check the same queries in viSQL.

What problems you have?

1) it returns error?

2) not correct result?
Then I see 2 problems:
A) reindex db
B) may be your db use other DateTime Format.
    e.g. It can use MDY but you send DMY 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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------