Convert and populate date of String type to the Date type field using field map script(transform map

[kamadi lokeshra]

Hi Everyone,
I need script for Convert and populate date of String type to the Date type field using field map script(transform map).

Thanking for your response in advance.

[Ankur Bawiskar]

@kamadi lokeshra 

you need not worry to convert string to Date

If your excel/file contains date in MM-dd-yyyy format then simply set that format in your field map and system takes care of everything

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@kamadi lokeshra 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[kamadi lokeshra]

Hi @Ankur Bawiskar ,@Swapna Abburi 

It is not working as expected. 

[Swapna Abburi]

Hi @kamadi lokeshra 

You can specify the date format in the transform map field mapping. This will convert the string data from your source record to the date and time format you gave and map the data to target field.

Please refer to attached screenshot.