2014943715 - Added date variables
For the [cdate] and [cdatetime] variables, the date or time offset for these variables has been improved.
use case => result
[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] => 2019-11-12
[cdate - 4 hours] => 2019-11-14 20:00:00
[cdate - 5 minutes] => 2019-11-14 23:55:00
[cdate - 6 seconds] => 2019-11-14 23:59:54
[cdatetime
Original question is available on version: ru
use case => result
[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] => 2019-11-12
[cdate - 4 hours] => 2019-11-14 20:00:00
[cdate - 5 minutes] => 2019-11-14 23:55:00
[cdate - 6 seconds] => 2019-11-14 23:59:54
[cdatetime
Answers:
Does not work in the "Calculate value by formula" action. Works only as current date [cdate]. When adding days or months, I show 1970-01-01
08.04.2023, 00:38
Original comment available on version: ua
found a solution - it is necessary to write in the formula like this [cdate] + 24 days
08.04.2023, 00:51
Original comment available on version: ua
#156508 wrote:
Does not work in the "Calculate value by formula" action. Works only as current date [cdate]. When adding days or months, I show 1970-01-01
Good day! If you have questions about the described modifications, it is better to write a separate question. Since no one sees comments in this category. This category was created on the forum to inform about new features of the system
08.04.2023, 17:37
Original comment available on version: ua
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
Copyright © OneBox 2024
