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... Subtract Time from Dat...

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

Suggested Answer

Subtract Time from DateTime Variable

(0) Share

Report

Report

Posted on by Johnson_Patrick

102

Hi,

I am looking to subtract Time from a DateTime Variable.

For Eg: If I -6 hrs from the DateTime Variable = 21-03-23 03:00:00 AM, it should return me 20-03-23 09:00:00 PM.

Let me know if you can help.

Thanks

Johnson Patrick

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

Use the duration datatype and say

TimeDate + Duration := NewDateTime as documented here:

learn.microsoft.com/.../duration-data-type

Was this reply helpful? Yes No
Johnson_Patrick 102 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your reply. My offset time is stored as a Integer, so how do i use integer variable to subtract from the DateTime variable?

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,850 Super User 2026 Season 1

#2

YUN ZHU 1,045 Super User 2026 Season 1

#3

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans