Time - time = integer.Numeric Expression in Data type Time?

Business Central/NAV Developers Forum
1

Time - time = integer.

I have 4 fields

  1. No.
  2. From Time
  3. To Time
  4. Response

i use code like this → Response := “To Time” - “From Time”;
what’s wrong with this?
it should be [data type time] - [data type time] = [data type integer]

2

There is nothing wrong with it. Subtracting a time from another time results in an integer that contains the difference in milliseconds.

3

have you tried it?

4

Yes, and it is working since I have the datatype Time. Same with DateTime.

OBJECT Codeunit 55555 Time
{
OBJECT-PROPERTIES
{
Datum=06.02.08;
Zeit=12:44:04;
Ge„ndert=Ja;
Versions Liste=;
}
PROPERTIES
{
OnRun=BEGIN
Time1 := TIME;
Datetime1 := CURRENTDATETIME;
SLEEP(600);
Time2 := TIME;
Datetime2 := CURRENTDATETIME;
Result := Time2 - Time1;
MESSAGE('Diff. time '+FORMAT(Result));
Result := Datetime2 - Datetime1;
MESSAGE('Diff. datetime '+FORMAT(Result));
END;

}
CODE
{
VAR
Time1@1000000000 : Time;
Time2@1000000001 : Time;
Result@1000000002 : Integer;
Datetime1@1000000003 : DateTime;
Datetime2@1000000004 : DateTime;

BEGIN
END.
}
}

5

interesting !!

i tried your code

thanx :slight_smile:

6

Fine. But please don’t forget that the result is in miliseconds (as Alain said already).

7

Ok thanks :slight_smile:

I already divide it, so it would be a “second”

8

…to display the result in a more “readable” way:

tiFrom := TIME;
…
tiTill := TIME;
tiDiff := 0.0T + (toTill - tiFrom);

MESSAGE(
‘%1 ÷ %2 = %3’,
tiTill,
tiFrom,
FORMAT(tiDiff, 0, ‘<hours24,2>:<minutes,2>:<Seconds,2>’) //…or whatever format wanted
);