Convert Date DDMMMYY to MM/DD/YY Format
DFSORT doesn’t have a built-in function for Convert Date – interpreting the month field of date in DDMMMYY formats as numeric values but you can use INREC and OUTREC statements to translate the month back and forth. Let’s take an example assuming that the DDMMMYY date is in positions 1-7. BUILD=(3,3, 3,3, CHANGE=(2,C’Jan’,C’01’,C’Feb’,C’02’,C’Mar’,C’03’,C’Apr’, C’04’,C’May’,C’05’,C’Jun’,C’06’,C’Jul’,C’07’,C’Aug’,C’08’, C’Sep’,C’09’,C’Oct’,C’10’,C’Nov’,C’11’,C’Dec’,C’12’), […]
Convert Date DDMMMYY to MM/DD/YY Format Read More »