Description: This solution describes how to format a date field for sending to Luminate Online

Environment: All

Versions: All

Answer:

The date format required by the Luminate Online API is YYYY-MM-DDT00:00:00 and the format provided by systems of record such as Altru or BBCRM may be different.

When sending dates to LO, the date will need to be reformatted. A Cleanup function can be applied to reformat the date during export.

1. In the formula on the Data Mapping page, click on the Gear icon to open the Actions menu

2. Select Clean Up

3. In the Date and Time Format drop down, select the yyyy-MM-ddTHH:mm:ss.fffZZZ option