Versions Compared

Old Version 1

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

Saved on

compared with

New Version Current

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

Saved on

Key

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

TODAY

This function returns the current date of the server. The date is given as base type date, formatted as dd-mm-yyyy.

Syntax

Panel
bgColorwhite

MINUTE


This function returns Returns the minute of a dateTime value. The minute is returned as a number an integer in the range 0 - 59.


Syntax

Code Block
MINUTE ( dateTime )


Inputs
  • dateTime - The dateTime value of which the minute must be returned.


Return type

  • integer


Examples

ExpressionResultType
MINUTE ( DATETIME ( 2015 , 5 , 25 , 00 , 00 , 00 ) )0Integer

SECOND

This function returns the second of a dateTime value. The second is returned as a number in the range 0 - 59.

Syntax

Code Block
SECOND ( dateTime )
Inputs
  • dateTime - The dateTime value of which the second must be returned.

Return type

  • integer

Examples

ExpressionResultType
MINUTE ( DATETIME ( 2015 , 5 , 25 , 23 , 45 , 00 ) )45Integer

Back to top

Panel
bgColorwhite
SECOND ( DATETIME ( 2015 , 5 , 25 , 00 , 00 , 00 ) )0IntegerSECOND ( DATETIME ( 2015 , 5 , 25 , 23 , 45 , 59 ) )59Integer

Back to top

Panel
bgColorwhite
Code Block
TODAY

Return type

  • date
UI Text Box
typenote
The TODAY function returns a date stamp. It is only recalculated when the expression in which you use the TODAY function is reevaluated. This recalculation will not cause other expressions that use the TODAY function to be reevaluated.

Back to top

Panel
bgColorwhite

NOW

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
typenote
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.

Back to top

...

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

...

Back to top

...

bgColorwhite

DAYOFWEEK

...

  • 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
Examples

...

Integer


Back to top