LinkedIn Company Page | DATE_FORMAT_IS_INVALID
Trailblazer Community

LinkedIn Company Page | DATE_FORMAT_IS_INVALID

Marketing Cloud Intelligence , Marketing Cloud Intelligence Integrations

Last updated 3 days ago ·Reference W-11298165 ·Reported By 4 users

No Fix

Summary
Clients are unable to map the field 'post_created' within a formula for the Day dimension; attempting to do so may fail processing with the following error:
class com.datorama.core.service.validation.LandingzoneException-LandingzoneException: The field 'post_created' in the uploaded file has not been identified by the system as a date, meaning it is not a date, or it has an un-identifiable format different than the one originally used to define the stream.

LandingzoneException [processError=DATE_FORMAT_IS_INVALID,Message=The field 'post_created' in the uploaded file has not been identified by the system as a date, meaning it is not a date, or it has an un-identifiable format different than the one originally used to define the stream.]

Repro
Sample formula used for the Day dimension, which sporadically fails during standard processing of the stream:
if (ISEMPTY(csv['post_created'])) {

return PARSEDATE(FORMATDATE_DEFAULT(csv['date_id']),"yyyy-MM-dd");

}

else {

return PARSEDATE(FORMATDATE_DEFAULT(csv['post_created']),"yyyy-MM-dd");

}

Workaround
Upload data as a TotalConnect

Updates
Engineering has determined this is not a bug because the file validation was specifically written to fail processing when there are more than 5 blank values in a file.

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.