Date Functions

The following Visual Basic commands have been tested with IDEA v9 and appear to be functioning properly. I have added some examples where possible on their use.

Second()

Second(date) Returns a value 0–59 representing the second of the minute

Time()

Returns the current system time (no date information).

TimeSerial

Use the TimeSerial function to create time values for type Date variables.

For TimeSerial, the values are normally in the range 0 to 23 for hours, and 0 to 59 for minutes and seconds. Larger values wrap to the next larger unit; therefore, a seconds value of 90 corresponds to one minute and 30 seconds

TimeValue()

Use the TimeValue function to create time values for type Date variables.

Weekday()

Returns a value 1–7 representing the day of the week. The optional firstdayofweek argument specifies the first day of the week; the default is Sunday. The firstdayofweek option in IDEAScript does not seem to work.

Year()

Year(date) Returns the year

Pages