• select [Date] = convert(date,'7/26/29')

    Results:

    Date

    ----------

    2029-07-26