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

(0) Share

Report

Posted on by Manuel Lozada

357

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Mohamed Amine Mahmoudi 26,294 Super User 2025 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

Was this reply helpful? Yes No
Verified answer

Manuel Lozada 357 on at

Like (0)

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.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,294 Super User 2025 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

Was this reply helpful? Yes No
Gerardo Rentería Ga... 22,524 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

Was this reply helpful? Yes No