Surprisingly, I found that someone was saving date as STRING in the following form 12/JAN/2019. I need to convert this to a regulardate format 03/29/2019 so I am able to compare the dates from these two columns (please check bellow). Any idea how to do that. Your help is much appreciated.Thanks.
Col1 Col2
12/JAN/2019 03/29/2019
Col 1 Col2 12/JAN/2019 03/29/2019