Is there a formula that calculates the due date?

[yakup aycıl]

Is there a formula that automatically enters the due date and calculates the due date?

I tried it but it didn't work; ifThen(not(empty(dueDay)),cDateDate= datetime\diff(today(), cDateDay, 'day'));

[victor]

This formula will suit you: https://docs.espocrm.com/administrat...atetimeadddays

- Three fields are created:
1. Number of days - Integer type;
2. Due Date - Date type;
3. Date Date - Date type.

- In Administration > Entity Manager > Your_entity_name > Formula > Before Save Custom Script enter the formula (be careful when specifying field names, because they may not start with "c"):

cDueDate = datetime\addDays(cDateDate, cNumberOfDays);

- You get an automatic calculation in the Due Date field:


If adding or subtracting days is focused only on the current date, then you do not need the Date Date field and the formula will look like this:

cDueDate = datetime\addDays(datetime\now(), cNumberOfDays);

[yakup aycıl]

Hello victor how are you

I did what you said but it didn't work. Where am I going wrong?

[Stefan]

Did you recalculate formula?

[yakup aycıl]

Yes, I calculated it but it still didn't come. Stefan

[victor]

Judging by your screenshot, you have confused field Labels and field Names.
Please send screenshots of the settings of all three fields used in the formula.

[yakup aycıl]

No, that's how I defined it.

[victor]

You did not send the screenshots that I requested from you, without them it's difficult to say anything.

As for the formula, it works as it should (checked both formulas personally).