End-of Date Function Calls

1 Introduction

End-of date function calls calculate the end of the day, week, month, or year and return the value.

The first parameter can be an attribute of an 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.

You can also calculate the end of a time period from the specified date. For more information, see Begin-of Date Function Calls.

2 endOfDay

The endOfDay function calculates the end of the day compared to the initial date.

2.1 Input Parameters

The input parameters are described in the table below:

2.2 Output

The output is described in the table below:

2.3 Example

endOfDay(dateTime(2007, 2, 7, 1, 1))

The output is:

"Wed Feb 07 23:59 CET 2007"

3 endOfWeek

The endOfWeek function calculates the end of the week compared to the initial date. The beginning and the end of the week are based on the user’s locale. In the case of an anonymous user, the browser’s locale is used instead.

3.1 Input Parameters

The input parameters are described in the table below:

3.2 Output

The output is described in the table below:

3.3 Example

endOfWeek(dateTime(2007, 2, 7, 1, 1, 1))

The output is:

"Sat Feb 10 23:59 CET 2007"

4 endOfMonth

The endOfMonth function calculates the end of the month compared to the initial date.

4.1 Input Parameters

The input parameters are described in the table below:

4.2 Output

The output is described in the table below:

4.3 Example

endOfMonth(dateTime(2007, 2, 7, 1, 1, 1))

The output is:

"Wed Feb 28 23:59 CET 2007"

5 endOfYear

The endOfYear function calculates the end of the year compared to the initial date.

5.1 Input Parameters

The input parameters are described in the table below:

5.2 Output

The output is described in the table below:

5.3 Example

endOfYear(dateTime(2007, 2, 7, 1, 1, 1))

The output is:

"Mon Dec 31 23:59 CET 2007"

6 Read More

• Date Creation
• Begin-of Date Function Calls