Expand my Community achievements bar.

SOLVED

Error mapping timestamp in Adobe CDP

Avatar

Level 4

Can someone help me to understand what this error is when im mapping my timestamp field to the timestamp in my event schema in Adobe CDP? Thank you

1 Accepted Solution

Avatar

Correct answer by
Employee

Hello @RyanMoravick 

 

The timestamp field requires an ISO 8601 format.  When you use the date function you should  specify a format.

 

Please refer the following as reference.

 

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions#date-and-time

View solution in original post

3 Replies

Avatar

Correct answer by
Employee

Hello @RyanMoravick 

 

The timestamp field requires an ISO 8601 format.  When you use the date function you should  specify a format.

 

Please refer the following as reference.

 

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions#date-and-time

Avatar

Level 4

Thanks @brekrut im trying to use this format for a timestamp coming from SFMC in my calculated field: 

date(DateTimeSent,"YYYY-MM-DD HH:mm:ss.SSS ±HH:mm",now())

 

this is the DateTimeSent value "2024-05-06 18:47:52.297 +01:00"

but there is nothing displayed in the preview and when I preview the data, the timestamp field is blank. Any suggestions on how to fix this?

Avatar

Level 4

Hey @brekrut you can disregard, I had the source field type set to string instead of date/time which was causing a weird formatting issue, but this is resolved. Thanks!