Need Help Creating a Date in EspoCRM Script

[huseyinerisen]

There is an entity named "prim" in EspoCRM. This entity has two fields as cOrderingDate (date), cPaymentDate (date).

1 month should be added to the month value found in the date value entered in the cOrderingDate field.

Then, the 15th of the month in the calculated new date should be written in the premium payment date field.

Examples;
if the order date is March 1, the premium payment date should be April 15,
if the order date is March 31, the premium payment date should be April 15.

In short, premiums are paid on the 15th of the following month.
Additional information: EspoCRM version 8.4.2.

I want to realize this request by writing to the "before save custom script" field with the formula feature in the "prim" entity.

Thanks in advance

[item]

Hi,
if i see, not possible out-of-box formula function, but you can do :

first, you must find "first day of next month'", so you won't have bug with february, and 30 or 31 day

after, you can add "15 day"

It's easy to make a custom formula. : https://docs.espocrm.com/development...on-in-formula/

$date = new \DateTime('myOrderDate');
$date->modify('first day of next month');
$date->modify('+15 days');
return $date->format('Y-m-d'); 

[huseyinerisen]

Thanks for your time. Solved it.

[yuri]

It can be done with formula.

Code to try in the Formula Sandbox. You can change the $orderDate to test how it works for different dates.

$orderDate = '2025-03-31';

$day = datetime\date($orderDate);
$monthStart = datetime\addDays($orderDate, (- $day + 1));
$nextMonthStart = datetime\addMonths($monthStart, 1);
$paymentDate = datetime\addDays($nextMonthStart, 15 - 1);

output\print($paymentDate);

[huseyinerisen]

Thank you Yuri, it worked and I am impressed by your way of thinking.

May I have your contact information for a possible professional collaboration?

[item]

Hi Huseyin
i agree, Yuri is a many many hight level... on top
i follow his work since long years.

For info : EspoCrm have a portal.espocrm.com .. there i have see we can buy "hours (something so)" .. but don't know how buy.