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

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

Inge M. Bruvik 32,748 Super User 2024 Season 1 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans