Subtract Date Function Calls

Introduction

Subtract date function calls subtract a time period from a date and time and return the modified value.

The first parameter can be an attribute of a domain model entity of type Date and time, a variable of type Date and time, or a Date and time value created using a Date Creation function. The second parameter specifies the time period to be subtracted. It is also possible to pass values of the Long type to different Subtract date function calls.

You can also add a time period to the specified date. For more information, see Add Date Function Calls.

subtractMilliseconds

The subtractMilliseconds function subtracts a specified number of milliseconds from a date.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

subtractMilliseconds(dateTime(2007, 1, 1, 1, 1, 1), 1000)

The output is:

Mon Jan 01 01:01:00 CET 2007

subtractSeconds

The subtractSeconds function subtracts a specified number of seconds from a date.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

subtractSeconds(dateTime(2007, 1, 1, 1, 1, 1), 30)

The output is:

Mon Jan 01 01:00:30 CET 2007

subtractMinutes

The subtractMinutes function subtracts a number of minutes from a date.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

subtractMinutes(dateTime(2007, 1, 1, 1, 1, 1), 30)

The output is:

Mon Jan 01 00:30:01 CET 2007

subtractHours

The subtractHours function subtracts a number of hours from a date.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

subtractHours(dateTime(2007, 1, 1, 1, 1, 1), 1)

The output is:

Mon Jan 01 00:01:01 CET 2007

subtractDays[UTC]

The subtractDaysUTC function subtracts a number of days from a date. subtractDays uses the server’s calendar and subtractDaysUTC uses the UTC calendar.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

subtractDays(dateTime(2007, 1, 5, 1, 1, 1), 5)

The output is:

Mon Jan 01 01:01:01 CET 2007

subtractWeeks[UTC]

The subtractWeeksUTC function subtracts a number of weeks from a date using the UTC calendar as opposed to subtractWeeks which uses the server’s one.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

subtractWeeks(dateTime(2007, 1, 15, 1, 1, 1), 2)

The output is:

Mon Jan 01 01:01:01 CET 2007

subtractMonths[UTC]

The subtractMonthsUTC function subtracts a number of months from a date using the UTC calendar as opposed to subtractMonths which uses the server’s one.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

subtractMonths(dateTime(2007, 3, 1, 1, 1, 1), 2)

The output is:

Mon Jan 01 01:01:01 CET 2007

subtractQuarters[UTC]

The subtractQuartersUTC function subtracts a number of quarters from a date using the UTC calendar as opposed to subtractQuarters which uses the server’s one.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

Input: subtractQuarters(dateTime(2007, 4, 1, 1, 1, 1), 1)

The output is:

Mon Jan 01 01:01:01 CET 2007

subtractYears[UTC]

The subtractYearsUTC function subtracts a number of years from a date using the UTC calendar as opposed to subtractYears which uses the server’s one.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

Input: subtractYears(dateTime(2007, 1, 1, 1, 1, 1), 1)

The output is:

Mon Jan 01 01:01:01 CET 2006