A data engineer is using Data Prep to format data for ingestion. The data engineer needs to load Date/Time as Date values for a field called CustomerCreateDate. The use of this field does not require a time component and as is String based.
The JSON value in this example is '.platosaprod.customerCreateDateVZOOS-11 -04 15:44".
Which Data Prep functions and order should the data engineer use to format the date without the time component?
JSON is the file format supported for this use case. Reference: https://experienceleague.adobe.com/docs/experience-platform/data-access-api/data-access-api/data-access-api-overview.html?lang=en#supported-file-formats
Currently there are no comments in this discussion, be the first to comment!