Calculating the difference between two DateTimes

(0) Share

Report

Posted on by TESDEveloper

162

Hi,

I want to see if the Earliest Start / Date Time of a Job queue is older than 1 day ago. How do I do this?

For example

Todayy := CALCDATE('<CD-1D>',TODAY);

Time := Time;

    "Earliest Start Date/Time" := CREATEDATETIME(Todayy,Time);
    IntDifference := CURRENTDATETIME - "Earliest Start Date/Time";
    IF IntDifference > 1 THEN

This example returns a high value integer not what I am expecting.

*This post is locked for comments

All responses (2)

Answers (0)

ManishS 6,578 on at

Like (0)

Report

RE: Calculating the difference between two DateTimes

But why do you want to check job queue days, any specific reason.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Calculating the difference between two DateTimes

Check this link, you need to calculate duration and convert it into hours and minutes

dynamicsuser.net/.../datetime-duration