Date

AddToDateTime

Adds a given part value to the given DateTime.

Syntax

AddToDateTime ( Part , Value , DateTime )

Parameters

Part as String (required) Allowed values are 'Time', 'Year', 'Quarter', 'Month', 'Week', 'Day', 'Hour', 'Minute', 'Second', 'Millisecond' and 'Tick' (case-insensitive, can be pluralized). Type: String

Value The value to add to the DateTime. Type: Any

DateTime The DateTime to alter. Type: DateTime

Return Type

DateTime

AddToTimeSpan

Adds a given part value to the given TimeSpan.

Syntax

AddToTimeSpan ( Part , Value , TimeSpan )

Parameters

Part Allowed values are 'Time', 'Day', 'Hour', 'Minute', 'Second', 'Millisecond' and 'Tick'. Type: String

Value The value to add to the TimeSpan. Type: Any

TimeSpan The TimeSpan to alter. Type: TimeSpan

Return Type

TimeSpan

EndOfDateTime

Gets the DateTime representing the end of the given part of a given DateTime.

Syntax

EndOfDateTime ( DateTime , Part )

Parameters

DateTime The DateTime to get the end of the given part from. Type: DateTime

Part Allowed values are 'Year', 'Quarter', 'Month', 'Week', 'Day', 'Hour', 'Minute', 'Second', 'Millisecond' and 'Tick' (case-insensitive, can be pluralized). Type: String

Return type

DateTime

Now

Represents the current date and time.

Syntax

Now (  )

Parameters

No parameters

Return Type

DateTime

PartOfDateTime

Gets the given part of the given DateTime.

Syntax

PartOfDateTime ( Part , DateTime )

Parameters

Part as String (required) Allowed values are 'Date', 'Time', 'Year', 'Quarter', 'Month', 'Day', 'Hour', 'Minute', 'Second', 'Millisecond' and 'Tick' (case-insensitive, can be pluralized). Type: String

DateTime The DateTime where to get the part from. Type: DateTime

Return Type

Any

PartOfTimeSpan

Deprecated: Use BeginOfDateTime with Part 'Month'.

Gets the given part of the given TimeSpan.

Gets the DateTime representing the beginning of the month of a given DateTime.

Syntax

PartOfTimeSpan ( Part , TimeSpan )

Parameters

Part Allowed values are 'Day', 'TotalDay', 'Hour', 'TotalHour', 'Minute', 'TotalMinute', 'Second', 'TotalSecond', 'Millisecond', 'TotalMillisecond' and 'Tick'. Type: String

TimeSpan The TimeSpan where to get the part from. Type: TimeSpan

Return Type

Any

Deprecated: Use EndOfDateTime with Part 'Month'.

Gets the DateTime representing the ending of the month of a given DateTime

Deprecated!ToBeginOfMonth

Syntax

ToBeginOfMonth ( DateTime )

Parameters

DateTime The DateTime to get the beginning of the month from. Type: DateTime

Return Type

DateTime

BeginOfDateTime

Gets the DateTime representing the beginning of the given part of a given DateTime.

Syntax

BeginOfDateTime ( DateTime , Part )

Parameters

DateTime The DateTime to get the beginning of the given part from.

Part as String (required) Allowed values are 'Year', 'Quarter', 'Month', 'Week', 'Day', 'Hour', 'Minute', 'Second' and 'Millisecond' (case-insensitive, can be pluralized).

Return Type

DateTime

EndOfDateTime

Gets the DateTime representing the end of the given part of a given DateTime.

Syntax

EndOfDateTime ( DateTime , Part )

Parameters

DateTime (required): The DateTime to get the end of the given part from. Type: DateTime

Part (required): Allowed values are 'Year', 'Quarter', 'Month', 'Week', 'Day', 'Hour', 'Minute', 'Second', 'Millisecond' and 'Tick' (case-insensitive, can be pluralized). Type: String

Return Type

DateTime