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