Insert Current Date script step

Contents > Script steps reference (alphabetical list) > Fields script steps > Insert Current Date script step

Insert Current Date script step

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.

Web compatibility

This script step is web-compatible.

Description

Pastes the current system date into the specified field.

To perform a calculation with the current date, make sure the receiving field is defined as a date field.

Notes

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.

Example


Go to Record/Request/Page [First]
Enter Find Mode []
Insert Current Date [Select; Invoices::Invoice Date]

Script step categories

Contents > Script steps reference (alphabetical list) > Fields script steps > Insert Current Date script step