Convert String/Text to Date Object

JSilver1

I have a piece of text that is coming through as 2021-06-15T00:00:00Z and I need to parse this as 06/15/2021 and convert it a Date object so that comparisons can be made on it. How would I achieve that?

Alex Argumedo

Hello,

If you obtain the strings in the correct order, and if the text you get is always the same, try this:

=MID(datestring@row, 6, 2) + "/" + MID(datestring@row, 9, 2) + "/" + LEFT(datestring@row, 4)

change the column type to date and it should be converted

let me know if this solve the issue, and please mark as answer

Regards