Skip to main content
September 11, 2006
Question

Filter recordset by date ?

  • September 11, 2006
  • 1 reply
  • 523 views
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.
This topic has been closed for replies.

1 reply

Inspiring
September 12, 2006
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.
>


September 12, 2006
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.