Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please help for the below issue.
i have two columns with dates, one column with DD/MM/YYYY, DD-MMM-YY & DDMMYYYY format, how to convert all in one format.
Dates |
29/09/2019 |
26-Sep-19 |
20092019 |
another column with DD/MM/YYYY, DD-MMM-YY & DDMMYYYY format, additional 'YYYYMMDD' how to convert all in one format.
Dates |
29/09/2019 |
26-Sep-19 |
20092019 |
20190910 |
You can use date#() and alt() in combination. One example is here : Handling multiple date formats
Thanks it's working...