Date Format Formula

Paul Newcome

Exactly what formula do you have in the [Date Conversion] column (I remember there was a little back and forth with that), and making sure you have confirmed that it is definitely a date type column?

katie.mcelroy

I used the formula you provided but it is not pulling the correct date into the Created(helper) column.

=DATE(VALUE("23" + MID([Date WO Created]@row, FIND("/", [Date WO Created]@row, FIND("/", [Date WO Created]@row) + 1) + 1, 2)), VALUE(LEFT([Date WO Created]@row, FIND("/", [Date WO Created]@row) - 1)), VALUE(MID([Date WO Created]@row, FIND("/", [Date WO Created]@row) + 1, FIND("/", [Date WO Created]@row, FIND("/", [Date WO Created]@row) + 1) - (FIND("/", [Date WO Created]@row) + 1))))

I have dates in the original column(date WO Created) ranging from 2021 - 2023.

Paul Newcome

What does this one do?

=DATE(VALUE(MID([Date WO Created]@row, FIND("/", [Date WO Created]@row, FIND("/", [Date WO Created]@row) + 1) + 1, 4)), VALUE(LEFT([Date WO Created]@row, FIND("/", [Date WO Created]@row) - 1)), VALUE(MID([Date WO Created]@row, FIND("/", [Date WO Created]@row) + 1, FIND("/", [Date WO Created]@row, FIND("/", [Date WO Created]@row) + 1) - (FIND("/", [Date WO Created]@row) + 1))))

katie.mcelroy

Woohoo! That worked and my formula's are working now. Thank you so much!

Paul Newcome

Happy to help. 👍️