Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gabeshackle

  1. gabeshackle

    Convert string field to date via sql

    I have a data field that is a type text in an existing database containing dates in the format mm/dd/yyyy and I'm trying to order the records by that field as a date. Is there anyway to convert this field to a date within the sql statement and then base the order off of that? Thanks.

Part and Inventory Search