I'm trying to convert V_String data type to DateTime formatt using DateTime Tool. The current V_String is DC/01/20 which is the equivalent to 01 Dec 2020. I'm struggling to specify the formatt for the incoming string. I sense that I may need to use Regex tool. Here are more example of dates that I am trying to convert: NV/24/20 (24 November 2015); AP/07/11 (11 April 2011). Any help is much apprecaited
Solved! Go to Solution.
Hi @MarkPitcock,
If you will create a mapping with a proper name of the month you can use Find and replace tool in order to achieve the correct date format.
Just create a proper mapping file as the second text input tool and my solution should work for you perfectly:
The ouput:
Please mark my post as a solution if this was helpful for you.
Good luck!
Thank you so much. i wish I'd have thought of that
Hi @MarkPitcock
Please check the attachment. You are absolutely right that, the main problem here is the Date format. You can also use Find and Replace tool. But for that you need another file. Here I use Formula tool to change the given date format. Hope it fulfil your requirement.
Thank you this will work as well