Conversion of Date Ordinal Indicator

[Felix776]

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

[grazitti_sapna · Accepted 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!

[patrick_mcauliffe · Accepted solution]

Probably an easier way to do it, but here's what I came up with.

[grazitti_sapna · Accepted solution]

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.

[Felix776 · Accepted solution]

Hi All,

I managed to find a way to identify the indicators, I used ** to identify the indicators!