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.

All responses (2)

Answers (1)

Verified answer

Teddy Herryanto (Th... 13,637 Moderator on at

Like (0)

Report

RE: DateTime Calculation

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

JAngle 89 on at

Like (0)

Report

RE: DateTime Calculation

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