DateTime Add

Kalipso - Form - Expressions - Functions - Functions Descriptions - Date Functions - DateTime Add

This Function returns a <string>, which is the date time resultant of the sum between the specified Date Time and Value.

Parameters

• Date Time <string> - Date Time to add the Value to. This parameter must be in format YYYYMMDDHHMISSCCC.

• Value Unit <string> - Unit of Value to add to Date Time. The Possible values for this parameter are:

  • "S" - Second

  • "M" - Minute

  • "H" - Hour

  • "D" - Day

  • "HHMMSS" - Time

  • "DDHHMMSS" - Date Time

• Value <string> - Value to add to Date Time. The unit of this parameter depends on the Value Unit.

Examples

• Example 1

DateTimeAdd("20100301091530000", "D", "1") Result = 20100302091530000

• Example 2

DateTimeAdd("20100301091530000", "HHMMSS", "010000") Result = 20100301101530