ENDOFCURRENTWEEK

Returns the end date of the current week. The time returned is 11:59:59 PM.

Syntax

= ENDOFCURRENTWEEK()

Parameters

None

Return Type

DateTime. The function returns a Microsoft .NET DateTime object. Any properties or member functions of the DateTime object can also be accessed or used in formulas.

Examples

Example	Returns
= ENDOFCURRENTWEEK()	If SYSTEM date is 1/28/2010: 2/6/2010 11:59:59 PM.
= ENDOFCURRENTWEEK().Day	The day for end of the current week.
= ENDOFCURRENTWEEK().AddDays(7)	The date and time for the end of the next week.
= ENDOFCURRENTWEEK().AddDays(7).Day	The day for the end of the next week.

Reference

http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx