User Tools

Site Tools


DATE CONVERSION

Guide Section: Processing Events and Performing Actions | EASAP Tree: EVENT PROCESSING Branch


DATE CONVERSION converts a date from one pattern (Input Pattern:) to another (Output Pattern:).

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

Common input and output patterns are provided as drop downs, but more general patterns can also be entered as described in Date Formats in an EASAP.

DATE CONVERSION
Essential Parameters:
Value:Reference to a DOR
Input Pattern:The date pattern corresponding to the input value. See Date Formats in an EASAP.
Output Pattern:The desired output pattern. See Date Formats in an EASAP.

Note: When EASA interacts with Excel dates are exchanged as a single number. The pattern “Excel Date” allows dates in other formats to be converted to or from this format.