How to transform and ingest month name in Data prep?

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.

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 Tof_Jossic

@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:

Tof_JossicAccepted solution

Employee

@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:

Sign up