Add days to a date

[maxinic]

Hello, I'm doing a bookings register
In this register I have an initial date field and a nights field
I can't add the starting date to the nights

I tried this



I have a calc element named End:

$night= (int) ('{registro_foresteria___num_notti}');
return "'".date('d-m-Y', strtotime('{registro_foresteria___start}' . '+ '. $night. ' day'))."'";

Ex.

Start: 08-06-2021
Night:2

it return 08-06-2021

 

[troester]

Try with element "raw" placeholders {...._raw}

 

[maxinic]

No
For me the problem is here:

$night= (int) ('{registro_foresteria___num_notti}');
return "'".date('d-m-Y', strtotime('{registro_foresteria___start}' . '+ '. $night. ' day'))."'";

it return correctly the date in '{registro_foresteria___start}' but it does not add up

 

[troester]

Var_dump or dump (jdump extension) what you get where.
Depending on your element settings {registro_foresteria___num_notti} may contain a link, that's why I said try _raw
{registro_foresteria___num_notti_raw}

 

[maxinic]

Solved.
i only change name from {registro_foresteria___num_notti} to {registro_foresteria___notti}, and add _raw. Thanks troester

 

[maxinic]

Another little problem.
It return date like '10-06-2021'. So when i found a date like 10-06-2021 finds nothing.
is there a way to delete the quotes?
I also thought about copying the result of the calc element into another date element but I don't know how to do it

 

[lousyfool]

1. Look at your code, it's you adding those quotes:

return "'".date('d-m-Y', strtotime('{registro_foresteria___start}' . '+ '. $night. ' day'))."'";

2. You could use a PHP form plugin to copy values elsewhere: http://fabrikar.com/forums/index.php?wiki/php-form-plugin/

 

[maxinic]

1. Look at your code, it's you adding those quotes:

Ops..
I had tried and it gave me error. I was wrong because I didn't delete the point too. Thank you

 

[maxinic]

Sorry, but why it is not saved in the database?
In Php myadmin nothing is saved
I set "Save to database"=Yes

 

[juuser]

Is "Only calc on save" set to "Yes" in your calc element settings?

 

[maxinic]

Is "Only calc on save" set to "Yes" in your calc element settings?

Now Yes