These functions are valid both for in SQL expressions and for use in a field, computed field, parameter expression or within label/report/request code.
Function |
Description |
Date () |
returns the current date |
Time () |
returns the current time |
DateAdd( date, field, amount ) |
returns the date with the field altered by the amount specified.
The field may be one of:
Calendar.YEAR Calendar.MONTH Calendar.DATE Calendar.ERA Calendar.WEEK_OF_YEAR Calendar.WEEK_OF_MONTH Calendar.DAY_OF_WEEK_IN_MONTH Calendar.DAY_OF_YEAR Calendar.DAY_OF_WEEK Calendar.HOUR_OF_DAY Calendar.HOUR Calendar.MINUTE Calendar.SECOND Calendar.MILLISECOND Calendar.AM_PM
The amount can be an integer number either positive or negative.
|
DayName (date) |
returns the name of the day |
DayOfMonth (date) |
returns the day of the month (1-31) |
DayOfWeek (date) |
returns the day of the week (1 means Sunday) |
DayOfYear (date) |
returns the day of the year (1-366) |
Hour (time) |
return the hour (0-23) |
Minute (time) |
returns the minute (0-59) |
Month (date) |
returns the month (1-12) |
MonthName (date) |
returns the name of the month |
Now () |
returns the current date and time as a timestamp |
Quarter (date) |
returns the quarter (1-4) |
Second (time) |
returns the second (0-59) |
Week (date) |
returns the week of this year (1-53) |
Year (date) |
returns the year |