DateTime Calculation

(0) Share

Report

Posted on by Ade son

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 (0)

All responses (2)

Answers (1)

Suggested answer

JAngle 135 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,284 Super User 2025 Season 2 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