Forum Discussion
Date Format Conversion
Hi guys, I have dates in the format of dd-mmm-yy(01-Apr-17), is it possible to convert it to dd-mmm-yyyy(01-Apr-2017) ? Thanks Ajin
You can use "Add Column from Examples" option to enter the format you require in one or two records. It will detect automatically the required expected format and will populate for all other rows as well. Then replace the old column with new column.
That's cleaner than my solution since you can delete the old column.