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
- Read more about TimeSerial
- Log in or register to post comments
Day()
Syntax: Day(DateValue as Date) as integer
Day(date) Returns a value 1–31 representing the day of the month
Parameter: The DateValue must be a valid date.
- Read more about Day()
- Log in or register to post comments
Hour()
Hour(date) Returns a value 0–23 representing the hour of the day
- Read more about Hour()
- Log in or register to post comments
Minute()
Minute(date) Returns a value 0–59 representing the minute of the hour
- Read more about Minute()
- Log in or register to post comments
Month()
Month(date) Returns a value 1–12 representing the month of the year
- Read more about Month()
- Log in or register to post comments
Second()
Second(date) Returns a value 0–59 representing the second of the minute
- Read more about Second()
- Log in or register to post comments
Year()
Year(date) Returns the year
- Read more about Year()
- Log in or register to post comments
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.
- Read more about Weekday()
- Log in or register to post comments
FormatDateTime(Date, NamedFormat)
Date is the date expression to be formatted. NamedFormat is an optional constant that specifies how the date is formatted.
- Read more about FormatDateTime(Date, NamedFormat)
- Log in or register to post comments
Static Arrays
A static array has a fixed size or number of elements. You specify the array size when you declare it, and the size cannot change during program execution. The size will be one more than n because VBA array indexes start by default at 0.
You can use an integer variable or constant as the index.
- Read more about Static Arrays
- 2 comments
- Log in or register to post comments