Page History
...
You can use this function to create a dateTime value out of integers or numbers.
| UI Text Box | ||
|---|---|---|
| ||
| Numbers will be rounded to integers. |
| UI Text Box | ||
|---|---|---|
| ||
| There is also a conversion function DATETIME. |
Syntax
| Code Block |
|---|
DATETIME(year, month, day, hour, minute, second) |
- year - An integer value between and including 1 and 9999 that represents the year in the constructed date.
- month - An integer value between and including 1 and 12 that represents the month in the constructed date.
- day - An integer value between and including 1 and 31 that represents the day in the constructed date.
- hour - An integer value between and including 0 and 23 that represents the hours in the constructed time.
- minute - An integer value between and including 0 and 59 that represents the minutes in the constructed time.
- second - An integer value between and including 0 and 59 that represents the seconds in the constructed time.
Return type
- dateTime
Examples
DATETIME ( 2010 , 5 , 25 , 23 , 00 , 00 ) = 25-5-2010 23:00:00DATETIME ( -2010 , 5 , 25 , 23 , 00 , 00 ) = UNKNOWNDATETIME ( 2010 , 5 , 25 , 45 , 00 , 00 ) = UNKNOWN
| Include Page | ||||
|---|---|---|---|---|
|
DATE
You can use this function to create a date value out of integers or numbers.
| UI Text Box | ||
|---|---|---|
| ||
Numbers will be rounded to integers. |
| UI Text Box | ||
|---|---|---|
| ||
| There is also a conversion function DATE. |
Syntax
| Code Block |
|---|
DATE(year, month, day) |
- year - An integer value between and including 1 and 9999 that represents the year in the constructed date.
- month - An integer value between and including 1 and 12 that represents the month in the constructed date.
- day - An integer value between and including 1 and 31 that represents the day in the constructed date.
Return type
- date
Examples
DATE ( 2010 , 5 , 25 ) = 25-5-2010DATE ( -2010 , 5 , 25 ) = UNKNOWNDATE ( 2010 , 2 , 29 ) results in an error
| Include Page | ||||
|---|---|---|---|---|
|
...
This function returns the current date and time of the server. The date and time are given as base type dateTime, formatted as dd-mm-yyyy HH:mm:ss.
Syntax
| Code Block |
|---|
NOW |
Return type
- dateTime
| UI Text Box | ||
|---|---|---|
| ||
The NOW function returns a date- and timestamp. It is only recalculated when the expression in which you use the NOW function is reevaluated. This recalculation will not cause other expressions that use the NOW function to be reevaluated. |
| Include Page | ||||
|---|---|---|---|---|
|
WEEKNUMBER
WEEKNUMBER returns the week number within the year of a given date or dateTime value. The week number is returned as an integer in the range 1 - 53. Week 1 for a year is the earliest seven day period starting at Monday that contains at least 4 days from that year. This definition reflects the ISO 8601 Week dates definition.
For example, January 1, 2015 was a Thursday. Therefore week 1 of 2015 starts on December 29, 2014, and ends on January 4, 2015.
Syntax
| Code Block |
|---|
WEEKNUMBER ( date | dateTime ) |
- date or dateTime - The date or dateTime value of which the week number must be returned.
Return type
- integer
Examples
WEEKNUMBER ( DATE ( 2015 , 01 , 01 ) ) = 1WEEKNUMBER ( DATETIME ( 2014 , 12 , 28 , 0 , 0 , 0 ) ) = 1WEEKNUMBER ( DATE ( 2015 , 12 , 28 ) ) = 53WEEKNUMBER ( DATE ( 2016 , 01 , 02 ) ) = 53WEEKNUMBER ( DATETIME ( 2016 , 01 , 04 , 0 , 0 , 0 ) ) = 1
| Include Page | ||||
|---|---|---|---|---|
|
DAYOFWEEK
DAYOFWEEK returns the number of the day within the week of a given date or dateTime value, as follows:- Sunday = 1
- Monday = 2
- Tuesday = 3
- Wednesday = 4
- Thursday = 5
- Friday = 6
- Saturday = 7
| Code Block |
|---|
DAYOFWEEK( date | dateTime ) |
- date or dateTime - The date or dateTime value of which the week number must be returned.
- integer
DAYOFWEEK( DATE ( 2015 , 01 , 01 ) ) = 5DAYOFWEEK ( DATETIME ( 2015 , 12 , 28 , 0 , 0 , 0 ) ) = 2DAYOFWEEK( DATE ( 2016 , 01 , 02 ) ) = 7DAYOFWEEK( ? ) = ?
| Include Page | ||||
|---|---|---|---|---|
|
Overview
Content Tools