Convert to date
Converts a date, captured in text or numeric format, into a date format usable by MXO .
Dates provided for conversion must be in one of the following formats:
| Field | Description |
|---|---|
| Text | yyyy-MM-dd HH:mm:ssZ yyyy-MM-dd HH:mm:ss.SSSZ yyyy-MM-dd'T'HH:mm:ssZ yyyy-MM-dd'T'HH:mm:ss.SSSZ yyyy-MM-dd milliseconds from 1 January 1970 |
| Numeric | milliseconds from 1 January 1970 |
Example Use Case
A hotel group capture the start and end dates of a customers stay during their booking process. They want to use that information to promote offers to the customer, during their stay. To do so they need to convert the captured date values to a format usable by MXO , in decisioning.
Example Eligibility Rule
convert booking_start_date to date