dDate = {01/02/2001} cDay = PADL(DAY(dDate),2,"0") cMonth = PADL(MONTH(dDate),2,"0") Or dDate = {01/02/2001} cDay = RIGHT(DTOS(dDate),2) cMonth = SUBSTR(DTOS(dDate),5,2)