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

[Nick_2024]

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. 

is there a workaraound to manage this issue? 

thanks

[Pradeep_Kumar_Srivastav]

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 · Accepted solution]

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

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

--ssj