Hi,
I am looking for a solution, where i can convert numbers into date format.
On monthly basis i received a file where date is given as 20201231. So which meand it is 31st dec 2020.
But i need this to be 2020/12/31 in this format.
So data is very huge...it is around 50-60k rows and date is like earlier format only and date is different in every row. Like 1st row may have 20201231 and next row could be 20200725.
How can i do that?
I am looking for a solution, where i can convert numbers into date format.
On monthly basis i received a file where date is given as 20201231. So which meand it is 31st dec 2020.
But i need this to be 2020/12/31 in this format.
So data is very huge...it is around 50-60k rows and date is like earlier format only and date is different in every row. Like 1st row may have 20201231 and next row could be 20200725.
How can i do that?