AV1611 Posted March 29, 2006 Share Posted March 29, 2006 itdatshta.`it_date` >= {d '2006-02-28'} AND itdatshta.`it_date` <= {d '2006-03-28'}need the two dates in this snippet of php/sql to be todays date and the date from 90 days earlierhere's a starting point...???$today="{d '".date('Y-m-d')."'}";$90day= Quote Link to comment Share on other sites More sharing options...
kanikilu Posted March 29, 2006 Share Posted March 29, 2006 90 days prior to today would be:[code]$ninetyDay=date('Y-m-d', strtotime('-90 days'));[/code]Note: I changed the variable name because you can't start a variable with a number (e.g. $90day) Quote Link to comment Share on other sites More sharing options...
AV1611 Posted March 29, 2006 Author Share Posted March 29, 2006 I knew that about the number... it was an illustration...thanks for the answer... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.