expiresDate 30 date in the future

3 posts by 2 authors in: Forums > CMS Builder
Last Post: March 29, 2020   (RSS)

By kitsguru - March 28, 2020

I am trying to set the expires date 30 days into the future from now using the membership signup form.

      $colsToValues['createdDate=']     = 'NOW()';
      $colsToValues['updatedDate=']     = 'NOW()';
      $colsToValues['createdByUserNum'] = 0;
      $colsToValues['updatedByUserNum'] = 0;
      $colsToValues['disabled'] = 0;
      $colsToValues['expiresDate'] = '(NOW() + INTERVAL 30 DAY)' ;

The problem I am having is that the expiresDate is not set. In examining the insert statement, the value is quoted which is not a valid date.

NSERT INTO `cmsb_accounts` SET
`createdDate` = NOW(),
`updatedDate` = NOW(),
`createdByUserNum` = '0',
`updatedByUserNum` = '0',
`disabled` = '0',
`expiresDate` = '(NOW() + INTERVAL 30 DAY)'

If the quotes are not present, then the expiresDate is correct.

What is the best way to set the expiresDate using some interval.

Jeff Shields

Hi Jeff,

Just so you know, there's a lot of information about comparing dates in the CMSB Cookbook.

Stay safe,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php