[SOLVED] Substitution: How to calculate Today date + Days = Future date

When using [cb:date format="d-m-Y" /] this allow to display the current date. Now I would like add to this "Today date" a specific number of days coming from the value of a specific field [cb_validity].

My goal would be to place inside a delimiter [cb:date format="d-m-Y" /] + [cb_validity] for output the result. So in practice if [cb_validity] is equal to 10 and today we are the 5.6.2014, the result must be 15.6.2014.

How to do this ?
thank

Substitutions do not have any math functionality. It's not possible to do that with substitutions. You'd need to compute the date using CB Query Field for example and format it using SQL date format functions.

Ok you right, I solved the problem with this query:

SELECT DATE_FORMAT(DATE_ADD(now(), INTERVAL cb_field DAY), '%d.%m.%Y' ) FROM `jos_comprofiler` WHERE `user_id` = '[user_id]';

cheers

Hi,

it is an possibility to use like this: strtotime('[cb_userdate] + 1 days')?
It looks like strtotime have math function.

Greets

Lars

Not currently, but it's planned for next CB Auto Actions release after CB 2.0 goes Stable.

krileon wrote: Not currently, but it's planned for next CB Auto Actions release after CB 2.0 goes Stable.

Could you tell me if now Auto-Action allow to calculate date? It seem you have implemented strtotime but maybe not usable as a substitution. If yes I don't see how to format the value.

My goal would be to set a field with [today date] + [30 days] without using query field for make calculation.