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.
By kitsguru - March 28, 2020
Found the solution
$expiresDate = new DateTime();
$expiresDate->add(new DateInterval('P30D'));
$colsToValues['expiresDate'] = $expiresDate->format('Y-m-d') ;
By gkornbluth - March 29, 2020
Hi Jeff,
Just so you know, there's a lot of information about comparing dates in the CMSB Cookbook.
Stay safe,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php