How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix
my script will generate text file which have two fields
one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will work good if i have date format in yyyy/mm/dd

So anyone can help me converting the format from dd/mm/yyyy to yyyy/mm/dd or sort as it is but it should be from older to newer one

11/14/2005 "labqaxm"
11/14/2006 "labqaxm"
11/29/2004 "amadeus"
11/29/2008 "amadeus"
11/29/2004 "betty"
11/29/2004 "dhprrn"
11/29/2009"flash"
11/29/2004 "wilma"
11/29/2004 "wilma"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2008"dhprrn"
11/29/2007 "dhprrn"
11/29/2006"dhprrn"
11/29/2007 "dhprrn"
11/29/2005"dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2000"dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2010dhprrn"
11/29/2007 "dhprrn"
11/30/2010 "boesky"
11/30/2010 "boesky"

Thank you very much I will really appreciate any help
Im in trouble

Have you tried searching these forums first?

awk '{
      date=""
      date= substr($1,7,4)  substr($1,4,2) substr($1,1,2)
      print date, $0
    }' filename | sort -n |
    while read date rest
    do
        echo "$rest"
    done > newfile

#!/bin/ksh

while read line
do
        echo $line | cut -c1-10 | sed -e 's/\// /g' | read D M Y
        echo $Y/$M/$D$(echo $line | cut -c11-)

done < infile