format date in derived column

Question

hello,

the column in dataflow shows as follows:

column1

---

30-Apr-22

31-Oct-22

...

Question

in derived column, how can I have a column which shows the dates as follows:

new_column

---

2022-04-30

2022-10-31

...

thank you

Answer 1

Hi arkiboys,

Thank you for posting query in Microsoft Q&A Platform.

use expressions as toDate(col1, "dd-MMM-yy"). Here col1 is your column which contains dates.

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.