How to transform and ingest month name in Data prep?

[swastika_lal1]

Hi,

The source data is sending the date in format: "May 28 2020 8:07AM". I have to map this field to a dateTime field. How can I do it?

I tried using this as a calculated field with logic: date(Last_Status_Update_Date,"L dd yyyy h:mma"), but my field didn't get any values.

I will appreciate any help on how to transform this field to zoned dateTime format.

Thanks,

Swastika.

[Tof_Jossic · Accepted solution]

@swastika_lal1 I'm not a Data Prep expert I'm afraid but found these functions (to Convert a date string into a ZonedDateTime) if that helps:

https://experienceleague.adobe.com/docs/experience-platform/data-prep/functions.html?lang=en#date-an...