[Resolved] Converting a month name into a decimal

[Calahan]

I'm currently trying to convert a submitted month into a decimal representation of the month. I'm trying

$date = strftime("%m",($_POST['month_stats']))
print $date

to convert it into decimal but it's not working. Am I using the wong function?

[drew010]

im not sure those functions will print the desired results. try

switch(substr(strtolower($_POST['month_stats']), 0, 3)) {
case "jan": $month_decimal = 1; break;
case "feb": $month_decimal = 2; break;
case "mar": $month_decimal = 3; break;
case "apr" : $month_decimal = 4; break;
case "may": $month_decimal = 5; break;
case "jun" : $month_decimal = 6; break;
case "jul" : $month_decimal = 7; break;
case "aug": $month_decimal = 8; break;
case "sep": $month_decimal = 9; break;
case "oct" : $month_decimal = 10; break;
case "nov": $month_decimal = 11; break;
case "dec": $month_decimal = 12; break;
}

[Calahan]

Thanks for the reply, it has the desired effect in that the months can be converted into decimals but even though I have altered the code you provided me with to add zeros before the numbers 1-9 so that the query will work, it seems to be ignoring the zeros and therefore my query string looks like SELECT FROM TABLE WHERE blah LIKE ('2004-2%') instead of SELECT FROM TABLE WHERE blah LIKE ('2004-02%'). This causes the query to be empty.

Any suggestions?

[Calahan]

Nevermind, I fixed it.

🙂

Cheers.