web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Calculations on fields

Small and medium business | Business Central, N...

Suggested Answer

Calculations on fields

(0) Share

Report

Report

Posted on by Community Member

Hey guys,

I have created a new table Condition.

It consists of 3 columns: Code, Description & Duration.

In the client the fields are filled for example like that:

3M, 3 Months, 90 days.

Now I want to do some calculations.

Therefore I have created 2 more fields in another table: Earliest Date To Cancel and Latest Date To Cancel. In this table is also a field Condition, which has a Table Relation to the first mentioned table.

Now what I want to achieve is, the users chooses in field Condition 3M and then in field Earliest Date To Cancel is going to happen a calculation, which adds the 3 months to the current date.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Teddy Herryanto (Th... 14,300 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You need to have a date formula on your Condition table.

Then put something like this on the OnTrigger on the Condition

Cond.Get("Condition");

"Earliest Date To Cancel" := CALCDATE(Cond."Date Formula");

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,870 Super User 2026 Season 1

#2

YUN ZHU 1,138 Super User 2026 Season 1

#3

Dhiren Nagar 915 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans