Thanks for the help. I ended up running this in my user model. It
seems to work pretty well.
function activePosts ()
{
$posts = $this->find('all', array('conditions' => array(
array('DATE_ADD(Post.created, INTERVAL 30 DAY) >
CURRENT_DATE';
return $posts;
On Sun, Sep 12, 2010 at 3:12 PM, Lance wrote:
> I'm trying to create a expiration field for blog posts that will
> display something like 25 days to expiration. I added an expiration
> DATETIME field in my database. I want to make it 30 days from the
> created DATETIME field in my database. Can
I'm trying to create a expiration field for blog posts that will
display something like 25 days to expiration. I added an expiration
DATETIME field in my database. I want to make it 30 days from the
created DATETIME field in my database. Can anyone steer me in the
right direction. I imagine I'l