Convert text date, to date 2018-04-18
Daniel Wiant
✭✭✭
I have a primary field that contains date information and I need to convert it to a date, so that I can compare it against another date field.
The format of the text date is 2018-04-18, and I need to convert it to a date, and cannot find a formula to do that. Any help?
thanks d
Tags:
Comments
-
=DATE(VALUE(LEFT(text,4)),VALUE(MID(text,6,2)),VALUE(RIGHT(text,2)))
-
Perfect...thank you sir.
-
@rjudenberg thank you, did not know the VALUE function existed!
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!