नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Syntax
Date.EndOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as any
About
Returns the end of the week that contains dateTime. This function takes an optional Day, firstDayOfWeek, to set as the first day of the week for this relative calculation. The default value is Day.Sunday.
dateTime: Adate,datetime, ordatetimezonevalue from which the last day of the week is calculatedfirstDayOfWeek: [Optional] A Day.Type value representing the first day of the week. Possible values areDay.Sunday,Day.Monday,Day.Tuesday,Day.Wednesday,Day.Thursday,Day.FridayandDay.Saturday. The default value isDay.Sunday.
Example 1
Get the end of the week for 5/14/2011.
Usage
Date.EndOfWeek(#date(2011, 5, 14))
Output
#date(2011, 5, 14)
Example 2
Get the end of the week for 5/17/2011 05:00:00 PM -7:00, with Sunday as the first day of the week.
Usage
Date.EndOfWeek(#datetimezone(2011, 5, 17, 5, 0, 0, -7, 0), Day.Sunday)
Output
#datetimezone(2011, 5, 21, 23, 59, 59.9999999, -7, 0)