update example

The following event handler displays the last update date and time in a Text control on a form for the current row, in GMT format.

function Rowset_onNavigate

   local dUpdate 

   dUpdate = new Date( this.fields[ "_DBASELOCK" ].update ) // Convert to Date 

   this.parent.parent.updateText.text := iif( dUpdate.getDay( ) == 0, ; 

   "No update on record", "Last updated on " + dUpdate.toGMTString( ) ) 

The day of an invalid or blank date is zero.