Is it possible to covert a date with ordinal indicator using DateTime to the desired as show below?
17th December 2016 => 17/12/2016
1st August 2013 => 01/08/2013
Solved! Go to Solution.
Hi @Felix776 , I am afraid you cannot do that using just date time tool as ordnial date can be dates such as 17th, 22nd,1st,23rd so you may need to add separate date time tool and then make transformations which will make the process complex. Here I will recommend you a feasible solution.
If this post is acceptable then please mark it as a solution.
Thanks!
Hi @patrick_mcauliffe , I tried the same way as you did in the first run but I encountered an issue which I think can be ignored but still is an issue. Please have a look. If you will use "1st August 2016" as date it will replace the st in string "August" with "Augu" that is why I had to come up with the solution provided in my post.
Hi All,
I managed to find a way to identify the indicators, I used ** to identify the indicators!