2. PHPRunner General questions
  3. [SOLVED]  Insert a Date field with plus 30 days for new registration
This topic is locked
[SOLVED]

 Insert a Date field with plus 30 days for new registration

 		4/5/2014 10:31:03 AM
PHPRunner General questions
F
 F5447 author

Hi All,
I would like to ask another PHPRunner event.

I have a User table, in which I have several fields, and one of the field is TODATE field.
I would like to add a date in this TODATE field, with a date of NOW()+30 days.
Purpose: I would like to get new registration have 30 days trial period.
Question:How can I do this, in order that during registration, system (PHPRunner generated code) will insert a date of NOW()+30 days?
Thanks and regards,
F
 		F5447 author 4/6/2014

Hi all,
OK ... I got it works using the following:

DATE('Y-m-d H:i:s', strtotime("+30 days"))