Convert String to Date using XPATH
661862Jan 22 2011 — edited Feb 27 2020We are using Transform Activity to map source(String) to Target(Date) column.
We have a requirement where we need to convert string (MM/DD/YYYY) to Date(MM/DD/YYYY HH.MM.SS AM) format.
For example: If source column have a value *9/13/2004*...then we want to populate *9/13/2004 12:00:00 AM*.
Can some one suggest how to achieve this using xsl/xpath??
Thanks,
AB