Forum Moderators: open

Message Too Old, No Replies

query using a calendar?

         

tonynoriega

10:39 pm on Aug 21, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

1:01 am on Aug 22, 2007 (gmt 0)

10+ Year Member



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

5:00 pm on Aug 22, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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?