Formatting a Date Time Field in AJO | Community

Level 2

Solved

Formatting a Date Time Field in AJO

Forum|Forum|1 year ago
December 17, 2024
2 replies
1321 views

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

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 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") %}

DanSpigs1Author

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

Accepted solution

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