CALCULATED FIELDS WITH DATES

If i have field 1 ( start Date ) and field 2 (end date), how can i make a calculated field formula to add 280 days to field 1 and the result in date format show in field 2?



Edited 1 time(s). Last edit at 09/17/2018 07:58AM by eugenio.

Something like this in your custom function should work (I haven't checked it):

$date = $parameters_ar['start_date_field_name'];
return date('Y-m-d', strtotime($date. ' + 280 days'));

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin

when i add a custom function n the date field , it says custom function does not support date fields in red alert

i changed the target field type to text
it gives me empty space
no values just empty space

Fixed thankyou

Hello,
yes, I forgot to mention that calculated fields are only compatble with text, textarea and select_single field types. Yes you can switch the dadabik field type to text (and keep the db field type as date) but remember that you loose some features of the date field type e.g. you won't get any check on the date validity or date syntax if the user insert manually the date.

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin