2 weeks past date(mysql)

[pradeepjain]

Hello every one,

i have a form with a date .i need to display records of the form from the database and display all records of 2 weeks from the present date i.e 14 days record..so how to get the date 14 days back from current date


Thanks,
Pradeep

[hsriat]

strtotime may hep you.

[pradeepjain]

strtotime may hep you.

This is the sql command i am using.. i have put "??" for where i have doubt where i need to have a 14 day old date....how to get it i dont know....

SELECT
  ID, raised, ext, location, description, type,
  DATE_FORMAT(rdate,'%d %M %Y'),
  action,status,
  DATE_FORMAT(cdate,'%d %M %Y'),
  remark,handle
FROM complaint 
WHERE status='open' OR (rdate <= curdate() and rdate >= ??) 
 

[hsriat]

This is the sql command i am using.. i have put "??" for where i have doubt where i need to have a 14 day old date....how to get it i dont know....

$str_sql="select ID,raised,ext,location,description,type,DATE_FORMA T(rdate,'%d %M %Y'),action,status,DATE_FORMAT(cdate,'%d %M %Y'),remark,handle from complaint where status='open' or (rdate <= curdate() and rdate >= ?? )

What's the format of rdate?

[Atli]

Hi.

You can use the DATE_SUB function to do that.

SELECT DATE_SUB(NOW(), INTERVAL DAYS 14)
 

[Atli]

I've merged the duplicate thread you posted in the PHP forums into this one.
Please don't double post your questions.

And please post you code inside [code] tags, preferably formatted in such a way that we can actually understand it.

Thanks