Choose where you’d like to start

toStartOfMonth()

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

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

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

(OR)

<variable> = toStartOfMonth(<dateTimeValue>);

Parameter	Description	Data type
<variable>	Variable which will contain the returned date-time value.	DATE-TIME
<dateTimeValue>	The starting date of the month this date-time 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.	DATE TIME

Parameter

Description

Data type

Variable which will contain the returned date-time value.

DATE-TIME

The starting date of the month this date-time 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 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.

DATE TIME

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