Filter recordset by date ?

[Guest]

Hi - using asp/access/vbscript

I have a db table with a lot of records, all different dates.
How can I filter a recordset - only display todays records (filter by date where today is default )

Any?

Bjørn.

[Newsgroup_User]

Simply write a SQL statement like this

Select * from tablename
Where DateField = Date()

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"btn" <webforumsuser@macromedia.com> wrote in message
news:ee4l34$oqj$1@forums.macromedia.com...
> Hi - using asp/access/vbscript
>
> I have a db table with a lot of records, all different dates.
> How can I filter a recordset - only display todays records (filter by date
> where today is default )
>
> Any?
>
> Bj�rn.
>

[Guest]

Hi.
Thanx for reply - still have a problem

I use

SELECT *
FROM program
WHERE Dato = Date()

This works great on my local computer (Europe) - but when uploading file and test on server (US), i get no records displayed - (but they are there).

Any idea ?

Bjørn.

[Newsgroup_User]

probably it has to do with differences in date format between remote
server and the local one. how do you store dates? remember in the states
the standard is MM/DD/YEAR

btn wrote:
> Hi.
> Thanx for reply - still have a problem
>
> I use
>
> SELECT *
> FROM program
> WHERE Dato = Date()
>
> This works great on my local computer (Europe) - but when uploading file and
> test on server (US), i get no records displayed - (but they are there).
>
> Any idea ?
>
> Bj?rn.
>
>