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

rjudenberg

=DATE(VALUE(LEFT(text,4)),VALUE(MID(text,6,2)),VALUE(RIGHT(text,2)))

Daniel Wiant

Perfect...thank you sir.

jg124

@rjudenberg thank you, did not know the VALUE function existed!