TDiff function

Returns the seconds elapsed between two DateTime data type values.

Syntax

TDiff(DateTime-expression₁ , DateTime-expression₂)

Where:

DateTime-expression₁ , DateTime-expression_2:  
     Are valid expressions that can involve constants, functions, methods, variables, attributes, Procedures, Inline Formulas.
     Both results must match the DateTime data type or Data data type.   

Type Returned:
Numeric

Scope

Objects: Procedure, Transaction, Web Panel, Panel, Data Provider
Generators: .NET, .NET Framework, Java, Apple, Android, Angular

Description

Returns the seconds elapsed between the two DateTime values received as parameters (DateTime-expression₁ - DateTime-expression₂).
DateTime-expression₂ can be greater than DateTime-expression₁. In this case, a negative value is returned.

Notes:

• If the arguments support Milliseconds, the resulting numeric value contains decimals that represent the milliseconds.
• This function calculates the time difference even when any of the parameters have null values.

Samples

&Diff = TDiff(&LastTime, Now())

&Diff = TDiff(&VarFinalDateTime, &VarInitialDateTime)

See Also

• Difference method