Hop til hovedindhold

Date.EndOfWeek

Returnerer slutningen af ugen.

Syntax​

Date.EndOfWeek(
    dateTime as any,
    optional firstDayOfWeek as Day.Type
) as any

Remarks​

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: A date, datetime, or datetimezone value from which the last day of the week is calculated
  • firstDayOfWeek: (Optional) A Day.Type value representing the first day of the week. Possible values are Day.Sunday, Day.Monday, Day.Tuesday, Day.Wednesday, Day.Thursday, Day.Friday and Day.Saturday. The default value is Day.Sunday.

Examples​

Example #1​

Hent ugens slutning for 14-05-2011.

Date.EndOfWeek(#date(2011, 5, 14))

Result:

#date(2011, 5, 14)

Example #2​

Hent ugens slutning for 17-05-2011, 17:00:00-7:00, hvor søndag er den første dag i ugen.

Date.EndOfWeek(#datetimezone(2011, 5, 17, 5, 0, 0, -7, 0), Day.Sunday)

Result:

#datetimezone(2011, 5, 21, 23, 59, 59.9999999, -7, 0)

Category​

Date