Formatting a Date Time Field in AJO

Question

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

DavidKangni · Accepted Answer

@danspigs1

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

Mohan_Dugganab · Answer

Can you try it on the following line  {%= formatDate(toDateTimeOnly("2024-12-12T16:20:57.924Z"), "YYYY.MM.dd HH:mm:ss") %}

Sign up

Login with SSO

Login to the community

Login with SSO