Online PHP editor | refs for 2VINe

<?php function field_field($date, $field) { // Format yyyy-mm-dd or yyyy-mm or yyyy $length = strlen($date); if ( $length >= 4 ) { $year = substr($date, 0, 4); if ( $length >= 7 ) { $month = substr($date, 5, 2); if ( $length >= 9 ) { $day = substr($date, 8, 2); $start = "$year-$month-$day 00:00"; $day = str_pad(++$day,2,'0',STR_PAD_LEFT); $end = "$year-$month-$day 00:00"; } else { $start = "$year-$month-01 00:00"; $month = str_pad(++$month,2,'0',STR_PAD_LEFT); $end = "$year-$month-01 00:00"; } } else { $start = "$year-01-01 00:00"; $year = str_pad(++$year,2,'0',STR_PAD_LEFT); $end = "$year-01-01 00:00"; } return "$field >= '$start' AND $field < '$end'"; } else { return ' 1=1 '; } } echo field_field( '2010', 'me');