Choose where you’d like to start



The toStartOfWeek() function takes a dateTimeValue as an argument, and returns the starting date of the week the dateTimeValue falls in.

The date-time value will be returned in the format specified in Application Settings.

Note: Sunday is considered as the first day of a week.

Return Type

  • Date-Time


<variable> = <dateTimeValue>.toStartOfWeek();


<variable> = toStartOfWeek(<dateTimeValue>);
ParameterDescriptionData type
<variable>Variable which will contain the returned date-time value.DATE-TIME

The starting date of the week this date-time value falls in, will be returned.

The time value is not taken into account while using this function.

A runtime error will be encountered if:

  • the specified 2 digit date value exceeds the number of days in that month.
  • an incorrect month value is specified in 3 or more characters.

The function returns a null value if:

  • the month value is specified in less than 3 characters.
  • the hour value, or the minutes value, or the seconds value is specified in more than 2 digits.
  • the date value is specified in more than 2 digits.
  • the year value has more than 4 digits.

Please refer this help document to learn about the supported date-time formats.



currentDate = '15-Mar-2019 15:00:00';
startDate= currentDate.toStartOfWeek();         // returns '10-Mar-2019 00:00:00'

Get Started Now