change field 2 date format

from this input

WEBELSOLAR,29122009,1:1
WIPRO,15062010,2:3
ZANDUREALT,18012007,1:3

i want output as
WEBELSOLAR,20091229,1:1
WIPRO,20100615,2:3
ZANDUREALT,20070118,1:3

basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format

awk -F',' 'OFS="," {{$2=substr($2,5,4)substr($2,3,2)substr($2,1,2)} {print $1,$2,$3}}' data.file