Insert Current Date
Purpose
Pastes the current system date into the specified field.
See also
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.
•Go to target field specifies the field to paste the date into.
Compatibility
Where the script step runs | Supported |
FileMaker Pro | Yes |
FileMaker Server | Yes |
FileMaker Go | Yes |
Custom Web Publishing | Yes |
FileMaker WebDirect | Yes |
Runtime solution | Yes |
Originated in
FileMaker Pro 6.0 or earlier
Description
•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.
•If you manually select field data before you run this script step in FileMaker WebDirect, the script step performs as if you did not make a selection. To select field data before you run this script step in FileMaker WebDirect, use the
Set Selection script step.
Example 1
Goes to the Email History layout, inserts the current date in the Last Sent field, then goes to the original layout.
Go to Layout ["Email History"]
Insert Current Date [Select; Emails::Last Sent]
Go to Layout [original layout]
Related topics