Seems like this guy just needs his problem solved.
Prize: getting a job offer for a very unspecific web company based in India. Yay?
But, in the spirit of being constructive, he should probably forgo solving this in SQL, have PHP generate the date, then use the date as part of the SQL WHERE clause.