Page History
Back to top |
---|
...
bgColor | white |
---|
DAYOFWEEK
...
- Sunday = 1
- Monday = 2
- Tuesday = 3
- Wednesday = 4
- Thursday = 5
- Friday = 6
- Saturday = 7
...
Code Block |
---|
DAYOFWEEK ( date | dateTime ) |
...
Panel | |||||||||
---|---|---|---|---|---|---|---|---|---|
| |||||||||
NOWThis function returns 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
Return type
UI Text Box |
|
...
bgColor | white |
---|
WEEKNUMBER
This function 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 ) |
Inputs
- date or dateTime - The date or dateTime value of which the week number must be returned.
Return type
- integer
Examples
...
|
...
- integer
...
|