Compare Dates in Dreamweaver

[Sitehelp]

Is there a command in Dreamweaver MX that compares 2 text boxes, which will contain dates that are stored in MySQL. It will then print out all the dates that are inbetween them preferably underneath or on the next page. Cheers!

 

[Cheech]

No there isnt.

You could do this with DateAdd() and by just comparing the strings

[Peace][Pipe]

 

[eb24]

http://WWWebDesign:

Well, your question depends on what programming framework you are using to query your database. For example, if you are using ASP.NET, then there are a myriad of validation controls one can use.

Reply back with more details and I'm certain someone can assist you further.

 

[Sitehelp]

I am using PHP. What I want for the user to enter too dates in 01-01-2004 format. First they enter the Start Date then they enter an End Date. Then when they click submit a list of all CallsIDs in the DB will be listed that are between the two specified dates. Cheers

 

[eb24]

http://WWWebDesign:

Maybe I'm missing something hear, but it looks like what you are looking for is an SQL statement instead. I am assuming a user enters these two dates and then clicks on a button, correct? If so, that button should trigger off an SQL statement, either ad hoc or via stored procedure, and look something like this:

strSQL = "SELECT CallsID FROM tblCalls WHERE CallDate BETWEEN @Date1 AND @Date2 "

Hope this helps a bit.