Relative To Absolute Time
- Gary Cane
Operator Menu Location: Time
Operator Bitmap:
Functional Description:
The Relative to Absolute Time operator converts a relative representation of a date/time-consisting of the number of days and seconds since the epoch (midnight on December 31, 1999)-into an absolute representation, fully defined with MM/DD/YYYY and HH:MM:SS.
The operator has two inputs: the number of days ( 
) and seconds () since the epoch representing the date/time to be converted. The number of seconds input refers to the fractional part of a day and can range from 0 to 60ï‚´60ï‚´24-1=86,399.
The operator has three outputs for the date, including the year ( 
), month ( 
), and day ( 
), and three outputs for the time, including the hour ( 
), minutes ( 
), seconds ( 
). If the time is to be represented in 12-hour mode, a seventh output 
is used to indicate if the time is before noon (AM) or after noon (PM). A LOW value represents AM and a HIGH value represents PM.
Using a relative representation for a date/time is convenient for performing date arithmetic (e.g., finding the difference between two dates). An inverse operator is available to convert an absolute date/time representation into a relative one---see the Absolute To Relative Time operator.
User-Defined Properties:
Object Name. A string label that identifies the operator
Absolute Time Format. The time format represented by outputs 
; either 12-hour or 24-hour.
Comments: None.
See Also:
Relative To Absolute Time, Calendar, Time-of-Day Clock, Alarm Clock