Creating a view

[Viguela]

I would like to create a view of some records but in a certain time frame (between 2 dates).
Anyone knows the script?
I've been trying but always with errors.
HELP.

 

[Andel]

Here's a script which retrieves yourdatefield from 1/1/1980 to 1/1/1985.

CREATE VIEW date_range_view AS
SELECT * FROM yourtable
WHERE yourdatefield BETWEEN '1/1/1980' AND '1/1/1985'

Andel
andelbarroga@hotmail.com

http://andyb.8m.com