Error mapping timestamp in Adobe CDP | Community
Skip to main content
RyanMoravick
May 7, 2024
Solved

Error mapping timestamp in Adobe CDP

  • May 7, 2024
  • 1 reply
  • 1059 views

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.

 

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

1 reply

brekrut
Adobe Employee
brekrutAdobe EmployeeAccepted solution
Adobe Employee
May 7, 2024

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
May 7, 2024

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?