Logical functions – Juniper Systems Allegro CX Manual User Manual
Page 160

160 Allegro CX Owner’s Manual
Hour(time)
Returns the hour of a time.
Example: Hour(2:45) equals 2.
Minute(time)
Returns the minutes of a time.
Example: Minute(2:45) equals 45.
Month(date)
Returns the month of a date.
Example: Month(1/1/03) equals 1.
Now()
Returns the current date and time.
Second(time)
Returns the seconds of a time.
Example: Second(Time(1, 45, 20)) equals 20.
Time(hour, min, sec)
Returns a particular time. Time(1,45,0) equals 1:45.
TimeValue(timeText)
Converts a time in the form of text to a serial number.
TimeValue(“1:45”) equals 0.072917.
Today()
Returns the current date.
Weekday(date, type)
Returns the day of the week corresponding to a date. If type = 1 or
omitted returns: 1 (Sunday) through 7 (Saturday).
Example: Weekday(Date(2003,8,15)) equals 1.
Year(date)
Returns the year of a date.
Example: Year(Date(2003, 1, 1)) equals 2003.
Logical Functions
And(logical1, logical2, ...)
Returns TRUE if all its arguments are TRUE, otherwise returns
FALSE.
Example: And(FALSE, TRUE) equals FALSE.