Date problem

[preston2003]

Short and quick: This script pulls from a MSSQL database. I want to run a script on the 22nd of every month and this script has a date range. The range is set like this: E.g April 22 is the next date coming up,

$sql = "EXEC ScoreCard '03/22/07', '04/21/07'";
------------------------------------------------
$today = date("m/d/y");

how can i back date $sql = "EXEC ScoreCard '03/22/07', '$today';

I would like to count back from $today to '03/22/07'

Thanks

[iburyak]

Try this

[PHP]select datediff(d, '03/22/07',getdate())[/PHP]

[preston2003]

Thanks for the response, but i would like to count back 30 days every other month. This would help me not to change the script every 30 days.

[iburyak]

Then try this:

[PHP]select dateadd(d, 30, '03/22/07')[/PHP]

[preston2003]

This works!! Thanks a million.