User Tools

Site Tools


Guide Section: Processing Object Data | EASAP Tree: DATA PROCESSING Branch

REPEATED DATE CONVERSION converts a LIST of dates from the Input Pattern: to the Output Pattern:

For example REPEATED DATE CONVERSION is useful when taking data from a database and converting it into a form suitable for writing to an Excel range.

Common input and output patterns are provided as drop downs, but more general patterns can also be entered as described in the parameter help. For example a pattern of EEE would return the day of the week and yyyy would return the year. This can be a convenient way of extracting parts of a date.

Essential Parameters:
Value:Reference to a list DOR
Input Pattern:The date pattern corresponding to the input value
Output Pattern: The desired output pattern

Page Tools