Expand my Community achievements bar.

SOLVED

Date() function showing blank space after mapping step in source configuration

Avatar

Level 3

Hi all, 

 

i have seen that such a issue has been reported in jauary (https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform/issues-in-implementing-da...). I'm now experiencing the same.

 

we need to use this function in order to get only date and not time from this format 

2022-04-13T22:00:29Z

in the preview it seems working fine but when ingestion happens in the datatset the field is white. 

Nick_2024_0-1722672400730.png

 

is there a workaraound to manage this issue? 

thanks

1 Accepted Solution

Avatar

Correct answer by
Level 2

try with MM instead of mm. "MM" represents Month, "mm" represents minutes.

format(date(ava_subscribedate),"yyyy-MM-dd")

 

--ssj

View solution in original post

2 Replies

Avatar

Community Advisor

Hi @Nick_2024 
1- Ensure that the target field in the schema is set to accept tye required date format. Sometimes, if the field type is not correctly set, data might not be ingested.

2- As a debugging step, try transforming a static date value to see if the issue is with the transformation logic or the data itself.

Avatar

Correct answer by
Level 2

try with MM instead of mm. "MM" represents Month, "mm" represents minutes.

format(date(ava_subscribedate),"yyyy-MM-dd")

 

--ssj