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,111 Moderator on at

Like (0)

Report

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

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 2,606

#2

YUN ZHU 931 Super User 2025 Season 2

#3

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans