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