Error mapping timestamp in Adobe CDP

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

brekrutAccepted solution

Adobe Employee

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.

Accepted solution

Adobe Employee

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.

Translate

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?

Translate

Sign up