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... DateTime Calculation

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

Answered

DateTime Calculation

(0) Share

Report

Report

Posted on by Ade son

10

Hello Reader

I am trying to calculate the DateTime that was 7 days ago.

I tried to calculate it like that:

DateTime1 := DateTime2 - 7D;

But that doesn't work: (Error Message)

Constant value '7D' is outside the range for a Date. The syntax for defining Date format is yyyymmddD, where D is a mandatory letter. For example, 20180325D, read as the 25th of March, 2018.

I have the same question (1)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Suggested answer

JAngle 157 on at

Like (0)

Report
Copy link

Link copied!

Try using this: jpearson.blog/.../

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can split the date and time, and do calcdate on the date.

CalcDate := DT2DATE(Datetime2);

CalcDate := CalcDate('<-7D>',CalcDate);

DateTime1 := CREATEDATETIME(CalcDate,DT2TIME(DateTime2));

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

#2

YUN ZHU 995 Super User 2026 Season 1

#3

Teagen Boll 596 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans