Jump to content

Archived

This topic is now archived and is closed to further replies.

AV1611

backdating by 90 days

Recommended Posts

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 earlier

here's a starting point...???

$today="{d '".date('Y-m-d')."'}";
$90day=

Share this post


Link to post
Share on other sites
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)

Share this post


Link to post
Share on other sites
I knew that about the number... it was an illustration...
thanks for the answer...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.