News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Subtraction of two tim...

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

Suggested answer

Subtraction of two time fields in Business Central

(0) Share

Report

Report

Posted on by Dynamics 365 Busine...

700

Hi All,

I have to subtract two time fields in BC and display the result in the report.

trigger OnAfterGetRecord()

var

myInt: Integer;

begin

Dur := OfficeScheduleType."Scheduled End Time" - OfficeScheduleType."Scheduled Start Time";

end;

Variable Dur is of Integer datatype, in this case.

I tried the above code on report but getting the result as '0'.

Is there any other way to achieve it ?

Please suggest.

Thanks !

All responses Img

All responses (2)

Answers Img

Answers (0)

Dynamics 365 Busine... 700 on at

Like (0)

Report

RE: Subtraction of two time fields in Business Central

Thanks Saurav.

Is this the only correction that needs to be done here?
Suggested answer

Saurav.Dhyani 14,314 Super User 2025 Season 1 on at

Like (1)

Report

RE: Subtraction of two time fields in Business Central

Set variable Dur as Duration instead of Integer.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

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

#1

Sohail Ahmed 874

#2

YUN ZHU 829 Super User 2025 Season 1

#3

Mansi Soni 595

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans