Scripting | Date Tools

Date Tools includes the following scripts: 

Convert Date Time Zone

Converts a date fields source time zone to a new time zone.

Source Date

• • Source Time Zone
  • Source Date Time Field

Output Date

• • Output Date Format
  • Output Time Zone
  • Overwrite Source Fields
  • Output Field Suffix

Format Dates

Re-formats the date values of multiple date fields.

Setup

• • Output Date Format
  • Source Date Format ("Optional. Used to specify the format of the source date.")]

Date Field 1

• • Source Date1
  • Output Date1

Date Field 2

• • Source Date2
  • Output Date2

Date Field 3

• • Source Date3
  • Date Field 3

Date Field 4

• • Source Date4
  • Output Date4

Date Field 5

• • Source Date5
  • Output Date5

Merge Date Fields

Combines separate date and time fields.

Mask Option

• • Date Time Format

Date Field 1

• • OutputField1
  • DateField1
  • TimeField1

Date Field 2

• • OutputField2
  • DateField2
  • TimeField2

Date Field 3

• • OutputField3
  • DateField3
  • TimeField3

Date Field 4

• • OutputField4
  • DateField4
  • TimeField4

Date Field 5

• • OutputField5
  • DateField5
  • TimeField5

Sort Date Creator

Creates a sortable date field that applies the parent date to attachments.

Mask Options

• • Date Mask

Misc

• • Output Field
  • Date Sent
  • Date Rcvd
  • Date Crtd
  • Date Saved

Split Date Fields

Splits date and time fields into separate fields.

Mask Option

• • Date Mask
  • Time Mask

Date Field 1

• • OutputField1
  • DateField1
  • TimeField1

Date Field 2

• • OutputField2
  • DateField2
  • TimeField2

Date Field 3

• • OutputField3
  • DateField3
  • TimeField3

Date Field 4

• • OutputField4
  • DateField4
  • TimeField4

Date Field 5

• • OutputField5
  • DateField5
  • TimeField5

Validate Dates

Validates multiple date fields and reports on incorrect date values.

Setup

• • Output Error Field
  • Output Error Desc Field

Date Fields

• • Fields

Strict Validation (optional)

• • Strict Validation
  • Strict Validation Format