convert date type from string

데이터 타입을 날짜 형식으로 변경

UpperCase(totext(date(mid(totext({EXPORT_OE_INVOICE_HEAD.INVDATE},0,''),5,2)+'/'+ right(totext({EXPORT_OE_INVOICE_HEAD.INVDATE},0,''),2) + '/' + left(totext({EXPORT_OE_INVOICE_HEAD.INVDATE},0,''),4))))