Error mapping timestamp in Adobe CDP

[RyanMoravick]

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

[brekrut · Accepted solution]

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

[RyanMoravick]

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?

[RyanMoravick]

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!