beautypg.com

Logical functions – Juniper Systems Allegro CX Manual User Manual

Page 160

background image

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.