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
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
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?
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!