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.
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
@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:
@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: