The startofday() function

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

Usage

STARTOFDAY(date)

Parameters

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

Returns

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

Remarks

Sample

startOfDaySample.fls.xml

...
<textview label="Quick, Cinderella! It's midnight!"
  text='{FORMATDTL((STARTOFDAY(sysp.dtlFormOpen)), 
  (dtf yyyy"-"MM"-"dd" "HH":"mm":"ss))}'/>
...
The textview displays the current day reset to midnight

Figure 298. The textview displays the current day reset to midnight


Related links

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