The startofmonth() function

Resets the day, hour, and second portions of a dtl value.

Usage

STARTOFMONTH(date)

Parameters

Parameter Type Description
date (required) dtl The date to be reset.

Returns

A copy of the argument with the day portion set to 01, and the hour, minute, and second portions set to 00.

Remarks

Sample

startOfMonthSample.fls.xml

...
<textview label="Your salary's due any minute.
                It's "
  text='{FORMATDTL((STARTOFMONTH(sysp.dtlFormOpen)), 
    (dtf yyyy"-"MM"-"dd" "HH":"mm":"ss))}'/>
...
The textview displays the current month, reset to its very first second

Figure 297. The textview displays the current month, reset to its very first second


Related links

The startofyear() function   The startofday() function
Copyright © 2016 Mobilengine Corp. All rights reserved. version: 7.0.4.19927