Ø @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).