Versions Compared

Old Version 1

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (a.jansen)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DAYOFWEEK

This function 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
Syntax
Panel
bgColorwhite

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

ExpressionResultType
WEEKNUMBER ( DATE ( 2015 , 01 , 01 ) )1Integer
WEEKNUMBER ( DATETIME ( 2014 , 12 , 28 , 0 , 0 , 0 ) )1Integer
WEEKNUMBER ( DATE ( 2015 , 12 , 28 ) )53Integer
WEEKNUMBER ( DATE ( 2016 , 01 , 02 ) )53Integer
WEEKNUMBER ( DATETIME ( 2016 , 01 , 04 , 0 , 0 , 0 ) )1Integer


Back to top

Panel
bgColorwhite
Code Block
DAYOFWEEK ( date | dateTime )
Inputs
  • date or dateTime - The date or dateTime value of which the week number must be returned.
Return type
  • integer
Examples
ExpressionResultTypeDAYOFWEEK ( DATE ( 2015 , 01 , 01 ) )5IntegerDAYOFWEEK ( DATETIME ( 2015 , 12 , 28 , 0 , 0 , 0 ) )2IntegerDAYOFWEEK ( DATE ( 2016 , 01 , 02 ) )7IntegerDAYOFWEEK ( ? )UNKNOWNInteger

Back to top