I have an the input data file running in to thousands of rows.
Challenge:
There is a date coulmm (V_String) which is not uniform. There are two types of formats in the incoming date
1*. dd/mm/yyyy
2#. yyyy-dd-mm.
I need to standardize these to a single format.
* when i am using the String to Date to convert either to
- mm/dd/yyyy it throws Null.or any other similar formats
- dd/mm/yyyy it changes the format to yyyy-mm-dd (guess i am converting to the same thing here)
# In both the above conversions the rows with this date format throws null.
How do i standardize the date?
