Date() function showing blank space after mapping step in source configuration | Community
Skip to main content
N
Nick_2024
Level 4
August 3, 2024
Solved

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

  • August 3, 2024
  • 2 replies
  • 559 views

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-date-function/m-p/645240#M3738). 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. 

 

is there a workaraound to manage this issue? 

thanks

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 itsme_ssj

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

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

 

--ssj

2 replies

Pradeep_Kumar_Srivastav
Community Advisor
Pradeep_Kumar_SrivastavCommunity Advisor
Community Advisor
August 4, 2024

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.

itsme_ssj
itsme_ssjAccepted solution
Level 2
August 7, 2024

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

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

 

--ssj

Terms & ConditionsAccessibility statement

Loading footer...