next up previous contents index
Next: 7.11.9 Miscellaneous Functions Up: 7.11 Quick-Reference Guide to Previous: 7.11.7 Financial Functions

7.11.8 Date and Time 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 up previous contents index
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