query using a calendar?

[tonynoriega]

has anyone ever seen the ability to query using on of those popup calendars where you select a date?

i am now tasked with this.

thansk

[SteveLetwin]

That's not really a database concern. The query would be the same regardless of how the date is entered. The calendar popup is just some javascript tomfoolery.

[tonynoriega]

thats what i am trying to incorporate...

Is there some form of jscript that i can use to query a date range to get results form my dbase?

What i have currently is a table structured layout that displays a weeks worth of data....its a lead database essentially.

it shows how many records have been enterd, who entered them, when, why and every thing else...

the data is based on several queries that use INTERVAL 6 DAY, so it counts back the previous week to show the data...

what i want to do is use a calendar, if possible, to run the queries.....

instead of only using the current day and previous 6 days, as put into my query string.

i have searched for something, but mostly everything is just a basic calendar that populates a text field, or just shows dates....

any ideas or links you may know of?