Convert text date, to date 2018-04-18

Daniel Wiant
Daniel Wiant ✭✭✭
edited 12/09/19 in Formulas and Functions

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

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!