Convert String/Text to Date Object
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?
Tags:
Answers
-
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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!