Blank values inserted into Date Data type Field in Adobe Campaign Classic V8

[SantoshKa5]

Hi Team,

I have issue with Date datatype Column in Adobe campaign classic. Data inserted but with blank values, with below warning for that column.

I have values for Date column, 2022-04-29T05:02:38.000Z.

getting warning in Data loading activity

Warning : 04/17/2025 8:57:07 AM BAS-010048 The field 'Year' with value '2022-04-29T05' in '2022-04-29T05:02:38.000Z' is too long. Maximum of 4 characters.

Data Loading activity configuration for Data format,

Please help me on this issue.

Regards,

Santosh Kumar.

[SushantTrimukheD · Accepted solution]

Hi @SantoshKa5,

The error you're encountering is due to the date column in your input file being in ISO 8601 format with a UTC timezone (e.g., 2022-04-29T05:02:38.000Z).

To successfully insert dates into Adobe Campaign, you’ll need to convert them into the preferred format for import:

YYYY-MM-DD HH:mm:ss (e.g., 2022-04-29 05:02:38)

You can achieve this by using an Enrichment activity after the Data Loading step, or a JavaScript activity, to transform the ISO date into a format that Adobe Campaign can recognize and properly map into the schema.

Thanks
Sushant Trimukhe

[SantoshKa5]

Hi @SushantTrimukheD ,

Thanks for your response.

Its worked. But If I have more Date columns, I have to make this update to all the columns.

Instead, I tried another Option in the Data Loading Activity Data Type change to XM(ex:aaaa-mm-jjThh:mm:ss:sssZ).

My Date columns are update with below formatted Date.

Hope this will workflow for us.

Thank you.

[ParthaSarathy]

Hi @SantoshKa5 ,

In data loading activity select the data type as string for this attribute, and have an enrichment next to data loading and create a output column with this expression,

ToDateTime(date_field_from_file)

[SantoshKa5]

Hi @ParthaSarathy ,

Thanks for your response.

Its worked. But If I have more Date columns, I have to make this update to all the columns.

Instead, I tried another Option in the Data Loading Activity Data Type change to XML(ex:aaaa-mm-jjThh:mm:ss:sssZ).

I have shared screenshots in above my reply.

Thank you,

Santosh.