Formatting a Date Time Field in AJO | Adobe Higher Education

Level 2

Beantwoord

Formatting a Date Time Field in AJO

Forum|Forum|1 year ago
December 17, 2024
2 reacties
1351 Bekeken

I have a file coming in for a daily load which has a date time field formatted YYYY.MM.DD HH:MM:SS. Is there a way in AJO to format the field as it comes in so it can be read in. Currently it reads as null and looking at the documentation it needs to be in one of the accepted formats, which this isn't. I've tried several of the functions and it continues to be read as null.

Thanks

Journey Optimizer

Er kunnen geen reacties meer worden geplaatst op dit onderwerp.

Beste antwoord door DavidKangni

AJO supports ISO or UTC only. You can use data prep functions during your mapping

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

Thanks,

David

Adobe Employee

Can you try it on the following line

{%= formatDate(toDateTimeOnly("2024-12-12T16:20:57.924Z"), "YYYY.MM.dd HH:mm:ss") %}

DanSpigs1Auteur

Level 2

Thank you for your response. Where would I be putting this code? In the mapping during ingestion?

Adobe Employee

This will be in the message content as a personalization component

Community Advisor

Antwoord

Community Advisor

AJO supports ISO or UTC only. You can use data prep functions during your mapping

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

Thanks,

David

David Kangni