Creator Help

toStartOfMonth

This topic describes the syntax and usage of the toStartOfMonth function in Zoho Creator .

Description

Returns the first date of the month, for the specified date. For example, if date value is July, 04 2013, which is a Thursday, the function returns July,01,2013, the starting day of the month.

Syntax

toStartOfMonth(<date>)

The toStartOfMonth function syntax has the following arguments.

date - A date in date/date-time format that represents the date. 

Note: This function is supported only in free-flow scripting mode of Script Builder. 

Return Value

A date (datetime).

Example

a. In this example, the toStartOfMonth function returns the starting date of the month for the transaction date.

  toStartOfMonth(TransactionDate);

Top