How to calculate in a formula the number of the days since start the year with the current day

(1) Share

Report

Posted on by Manuel Lozada

465

Hi Community,

Do you know how to calculate in a formula the number of the days since start of the year with the current day?

In this case, I want to replace the number 116 that is the number of the days since start the year, with a field or variable that calculate this number automatically.

If you know how I would appreciate it.

Thanks

Categories:

Business Central

All responses (4)

Answers (1)

Mohamed Amine Mahmoudi 9,559 Super User 2024 Season 2 on at

Like (0)

Report

How to calculate in a formula the number of the days since start the year with the current day

Hi @Manuel,

Please verify the answers that helped.

Mohamed Amine MAHMOUDI
Verified answer

Manuel Lozada 465 on at

Like (1)

Report

How to calculate in a formula the number of the days since start the year with the current day

Thanks Mohamed I solved the problem according your code and Renteria link.
Suggested answer

Mohamed Amine Mahmoudi 9,559 Super User 2024 Season 2 on at

Like (0)

Report
How to calculate in a formula the number of the days since start the year with the current day

Hi @Manuel,

to calculate the number of days you need to use this code:

var dt: date; year: Integer; days : Integer; begin year := Date2DMY(Today(), 3); dt := DMY2Date(1,1,year); days:= Today() - dt; end;

Best regards,

Mohamed Amine MAHMOUDI
gdrenteria 12,183 Most Valuable Professional on at

Like (0)

Report

How to calculate in a formula the number of the days since start the year with the current day

Hi

This can help you.

https://community.dynamics.com/forums/thread/details/?threadid=f58c5a00-ee93-42e2-b6c7-72e5253cef1d

BR

GR