1b.app
Link copied -

2015539573 - Completion of the action "Calculate and write a value to an additional field if the conditions are met"

For the BP action “Calculate and write the value in the additional field if the conditions are met”, the ability to specify in the “formula” field that a certain number of days is added to the current date has been improved.
An example of how you can set values and what the result will be:
[cdate] => 2019-11-15
[cdate + 1 years] => 2020-11-15
[cdate + 2 months] => 2020-01-15
[cdate + 3 days] => 2019-11-18
[cdate + 4 hours] => 2019-11-15 04:00:00
[cdate + 5 minutes] => 2019-11-15 00:05:00
[cdate + 6 seconds] => 2019-11-15 00:00:06
[cdatetime] => 2019-04-15 15:00:00
[cdatetime + 1 years] => 2020-04-15 15:00:00
[cdatetime + 2 months] => 2019-06-15 15:00:00
[cdatetime + 3 days] => 2019-04-18 15:00:00
[cdatetime + 4 hours] => 2019-04-15 19:00:00
[cdatetime + 5 minutes] => 2019-04-15 15:05:00
[cdatetime + 6 seconds] => 2019-04-15 15:00:06
[cdate] => 2019-11-15
[cdate - 1 years] => 2018-11-15
[cdate - 2 months] => 2019-09-15
[cdate - 3 days]
Original question is available on version: ru

Answers:

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment