Need to convert the String attribute from source connector(Data landing zone) to Date time in AEP.
Tried to convert using below methods but either it is throwing an error or updating the empty values.
Please let us know is there any other process to perform it.
Eg: Source data(String-"20220607") Expected output(DateTime)
Solved! Go to Solution.
The field name should not be quoted.
I would also try, just in case
date(trim(field_name), 'yyyyMMdd')
Hey,
I tried with the below and got the result,
date('20220607', 'yyyyMMdd')
Views
Replies
Total Likes
Hi @birthariyamayank ,
Thanks for looking into the issue. Tried the above method still it return null values. PFA screenshot.
Thanks,
Vishnu K.
Views
Replies
Total Likes
The field name should not be quoted.
I would also try, just in case
date(trim(field_name), 'yyyyMMdd')
Thanks for looking this up further. But still get null values.
From Source column name is "Date Time". Tried both the methods nothing worked.
e.g: date(trim(Date_Time), 'yyyyMMdd')
date(trim(DateTime), 'yyyyMMdd')
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies