Date restriction
Hello,
Using MySql.
I have a field RegDate (timestamp) which enters the date when the record is created.
I want the record not to show after 30 days.
Can anyone say how this may be achieved please?
Many thanks
John
Hello,
Using MySql.
I have a field RegDate (timestamp) which enters the date when the record is created.
I want the record not to show after 30 days.
Can anyone say how this may be achieved please?
Many thanks
John
use a where clause, DATE_FORMAT(), and DATE_ADD():
WHERE DATE_FORMAT(RegDate, '%Y-%m-%d') < DATE_ADD(DATE_FORMAT(RegDate, '%Y-%m-%d'), INTERVAL 30 DAY)
Brilliant Jason worked first time.
I will now endeavour to get my head round the clauses!
Many thanks
John
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.