Workflows: dateEnd not set in Tasks

[snoo]

Hi,

i try to set the dateEnd from a Task from a targetEntityfield.
Following formula works:
"dateEnd = datetime\format(targetEntity\attribute('abrechnung stermin1'),,'YYYY-MM-DD hh:mm');"

now i dont want to set it to this date, but add days to that:

dateEnd = datetime\addDays(datetime\format(targetEntity\attr ibute('abrechnungstermin1'),,'YYYY-MM-DD hh:mm'), 30);

this doesnt work.

I also tried, but doesnt work either:

dateEnd = datetime\format(tdatetime\addDays(datetime\format( targetEntity\attribute('abrechnungstermin1'),,'YYY Y-MM-DD hh:mm'), 30),,'YYYY-MM-DD hh:mm');

any idea how to add 30 days with a formula?

best, mike

[tanya]

Hello
http://forum.espocrm.com/forum/exten...lt-on-workflow
think it's better
dateEnd = datetime\addDays(targetEntity\attribute('abrechnun gstermin1'), 30));
(why do you use double comma?)

[snoo]

because i need to set the datetime\format as 'abrechnungstermin1' is a date not a datetime.

[snoo]

also not working:

$endDate = datetime\format(targetEntity\attribute('abbrechnungstermin1'),null,'YYYY-MM-DD hh:mm');
dateEnd = datetime\addDays($endDate, 30);

[tanya]

did you try example, I typed?
what is the type of your field 'abbrechnungstermin1'?

[snoo]

yes. would be the same as above mention code, but without the minutesDiff, as I pass already 30 days to it.

[tanya]

Ok. I see it is date format. But what time do you want to set? Maybe you don't need a time for task, but only date

[snoo]

it doesnt matter what time i set.
the funny thing is, that this works:

dateEnd = datetime\format(targetEntity\attribute('abrechnung stermin1'),,'YYYY-MM-DD hh:mm');

and now I just want to add 30 Days to this date.
Shouldn't be too complicated.

[tanya]

tried this?

dateEnd = datetime\format(datetime\addDays(targetEntity\attr ibute('abrechnungstermin1'), 30),,'YYYY-MM-DD hh:mm');

by the way, you could have problem if you change time format in user preferences.
what about

dateEndDate = datetime\addDays(targetEntity\attribute('abrechnun gstermin1'), 30);

?
in this case time will be empty

[snoo]

dateEnd = datetime\format(datetime\addDays(targetEntity\attr ibute('abrechnungstermin1'), 30),,'YYYY-MM-DD hh:mm');

did the trick! thank you!