[RESOLVED] Doing a MySQL date query on a string date

[khovorka]

Hello,

I am trying to get the following SQL statement to work on a String date:

wght_date is a VarChar(12) and the date string is formatted as 2011-04-01;

$wghtstdate = '2011-04-01';
$wghtenddate = '2011-05-01';

$sql = "SELECT * FROM weight_history WHERE member_id=".$member_id.
       " AND str_to_date(wght_date, '%Y-%m-%d') BETWEEN '".$wghtstdate.
       "' AND '".$wghtenddate."'";

I have tried a number of other options as well and can't get anything to work
on this.

I am baffled at what to do on this after spending several hours trying different
conversions to the wght_date string in the query.

All help is appreciated.

Thanks,
Kim

[dagon]

the problem is your field type it should be date, not varchar