Juniper Systems Allegro CE Manual - Manual (Page 186)

Page 4-126 Windows CE
Date & Time Functions
Date(year, month, day)Returns a particular date.
Example: Year(Date(1999, 1, 1)) equals 1999.
DateValue(dateText) Converts a date in the form of text to a serial number.
Example: DateValue(“1/1/99”) equals 36161.
Day(date) Returns the day of a date.
Example: Day(1/1/99) equals 1.
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/99) 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(1999,8,15)) equals 1.
Year(date) Returns the year of a date.
Example: Year(Date(1999, 1, 1)) equals 1999.
Logical Functions
And(logical1, logical2, ...) Returns TRUE if all its arguments are TRUE,
otherwise returns FALSE.
Example: And(FALSE, TRUE) equals FALSE.
If(condition, trueValue, falseValue) Returns trueValue if condition
evaluates to TRUE or falseValue if condition evaluates to FALSE. Example:
If(A1>A2, “OK”, “Cancel”).
Not(logical) Reverses logical value.
Example: Not(TRUE) equals FALSE.
Or(logical1, logical2, ...) Returns TRUE if any argument is TRUE,
otherwise return FALSE.
Example: Or(FALSE, TRUE) equals TRUE.