DateTime Sub

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

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

Parameters

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

  • Value Unit <string> - Unit of Value to subtract from 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 subtract from Date Time. The unit of this parameter depends on the Value Unit.

Examples

  • Example 1

DateTimeSub("20100301091530000", "D", "1") Result = 20100228091530000

  • Example 2

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

PreviousDateTime DiffNextDateToString

Last updated