small error with dates

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 373,936 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,582 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 252 | Replies: 3

•

Join Date: Mar 2008

Posts: 63

Reputation: sukhy_1 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 3

sukhy_1

Offline

Junior Poster in Training

small error with dates

Mar 30th, 2008

Hello this statement below works when the date is set as 02/02/2008 but when i enter it like this 2/2/2008 it dont search the date, in the database the date is set as 2/2/2008 because i need it in that format. i want to search dates from and to like i have wrote in the statement.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
$sql = "SELECT DayofWeek, Bookingdate,  
FROM peter
WHERE Bookingdate
BETWEEN '%$value1%'
AND '%$value2%';
 
$sql = "SELECT DayofWeek, Bookingdate,  
FROM peter
WHERE Bookingdate
BETWEEN '%$value1%'
AND '%$value2%';