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

100

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)

Johnson_Patrick 100 on at

Like (0)

Report

RE: Subtract Time from DateTime Variable

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
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: Subtract Time from DateTime Variable

Use the duration datatype and say

TimeDate + Duration := NewDateTime as documented here:

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

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

#1

Sohail Ahmed 2,725 Super User 2025 Season 2

#2

Sumit Singh 2,610

#3

Jeffrey Bulanadi 2,221

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans