extract date

Thanks for the reply from rajendraongole1 and ray_aramburo.

Hi anoomohan ,

During my testing, both C and D options were able to get date columns with a hierarchical structure. The difference is that C will split the column into date and visual (the question doesn't talk about whether the time and original data are still needed), while column D needs to be extracted with the date in text form, which still needs to be formatted. If a correct answer is needed, then C is straightforward to get the desired result, while D requires an additional step, so I would choose C.

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.