Calculate duraion between two dateTime fields in BC Report

(0) Share

Report

Posted on by Nia

150

Hello Experts,

I want to calculate diff b/w two DateTime field in Business Central AL report.

I have added two fields in the table Purchase receipt and warehouse line.

Val1: DateTime= 01/07/2021 03:55 AM

Val2 DateTime: = 01/07/2021 03:56 AM

Val 3: Val2-Val1

Now i wanted to substract these two fields in separate column in report but it doesn't give correct result.

Any suggestions will be highly appreciated.

Thanks.

Nia

Categories:

I have the same question (0)

All responses (2)

Answers (0)

Join the conversation

Quick Links

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

YUN ZHU 733 Super User 2025 Season 2

Helpful resources