Insert Current Date
Purpose 
Pastes the current system date into the specified field.
Format 
Insert Current Date [Select; <table::field>]
Options 
  •
Select entire contents replaces the contents of a field with the current date. If you do not select this option, Insert Current Date adds the value of the current date to the end of the field's existing data.
  •
Select Go to target field or click Specify to specify the field to paste the date into.
Compatibility 
This script step is also supported in web publishing and in a FileMaker Server scheduled script.
Notes
  •
To perform a calculation with the current date, make sure the receiving field is defined as a date field.
  •
If the specified field does not exist on the layout where the script is being performed, Insert Current Date returns an error code which can be captured with the Get(LastError) function.
  •
In a web-published database, use a Commit Record/Request script step after an Insert Current Date script step to update the record in the browser window.
Examples 
Go to Record/Request/Page [First]
Enter Find Mode []
Insert Current Date [Select; Invoices::Invoice Date]
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.