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.

Best answer by brekrut

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.

brekrutAccepted solution

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.

New Participant

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?

Sign up