2 Replies Latest reply on Sep 13, 2013 1:41 PM by davidg5700

    Converting date in string format to date format

    davidg5700 Specialist

      Hello all,

       

      I am trying to create a query to find all our Lenovo laptops that are out of warranty.  The Thinkvantage tree of the inventory stores this information in a string field formatted like 2013-08-29.  Is there any way that I can convert this to a format where I can do a GetDate() comparison?

       

      Thanks.

       

      9.5 SP1