Returns the start date of the current week. The time returned is 12:00 AM.
= STARTOFCURRENTWEEK()
None
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.
Example |
Returns |
= STARTOFCURRENTWEEK() |
If SYSTEM date is 1/28/2010: 1/1/2010 12:00:00 AM. |
= STARTOFCURRENTWEEK().Day |
The day for start of the current month. |
= STARTOFCURRENTWEEK(“02/19/2009”).AddDays(-7) |
The date and time for the start of the previous week. |
= STARTOFCURRENTWEEK(“02/19/2009”).AddDays(-7).Day |
The day for the start of the previous week. |
http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx