Next: 7.11.9 Miscellaneous Functions
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.7 Financial Functions
- @DATE(Y, M, D) -
- The date value for year Y, month
M, and day D.
- @DATEVALUE(S) -
- The corresponding date value for a given
string S.
- @DAYS360(S, E) -
- The number of days between two dates,
based on a 30/360 day count system.
- @DAY(DT) -
- The day number in the date/time value DT.
- @EDATE(S, M) -
- The date/time value representing number of
months (M) before or after start date (S).
- @EOMONTH(S, M) -
- The date/time value representing the last
day of the month M months after S, if M is
positive, or M months before if M is
negative.
- @HOUR(DT) -
- The hour value (0-23) of date/time value
DT.
- @MINUTE(DT) -
- The minute value (0-59) of date/time value
DT.
- @MONTH(DT) -
- The number of the month in date/time value
DT.
- @NETWORKDAYS(S, E[, H]) -
- The number of whole working days,
starting at S and going to E, excluding
weekends and holidays.
- @NOW -
- The date/time value of the current system date and time.
- @SECOND(DT) -
- The seconds value (0-59) of the date/time
value DT.
- @TIME(H, M, S) -
- The time value for hour H, minute
M, and second S.
- @TIMEVALUE(S) -
- The corresponding time value for a given
string value S.
- @TODAY -
- The date value of the current system date.
- @WEEKDAY(D) -
- The integer representing the day of the week
on which the day D falls. 1 is Sunday, 7 is
Saturday.
- @WORKDAY(S, D[, H]) -
- The day that is D working days
after S, if D is positive, or before
S, if D is negative, excluding weekends and all
holidays specified as dates in range H.
- @YEAR(DT) -
- The year value of date/time value DT.
- @YEARFRAC(S, E[, B]) -
- The portion of the year represented by
the number of days between start date (S) and end
date (E).
Next: 7.11.9 Miscellaneous Functions
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.7 Financial Functions
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999