+ 0 Votes There isn't any 27th Month ... OldER Mycroft Updated - 5 years ago So unless you alter the sequence you input your data, it'll never work. Also, as far as I'm aware - this ain't the 1st Century. Having a single digit is probably confusing for you. + 0 Votes CYYMMDD format Jonathan.Davis 4 years ago CYYMMDD is an old IBM Date Format. When C = 0 the Century is 1900 C = 1 the Century is 2000. An easy way to handle this format is below INPUTDATE + 19000000 INPUTDATE will now be in CCYYMMDD format. Sometimes it takes an old programmer to teach new kids tricks. + 0 Votes Century code Ed Woychowsky Updated - 5 years ago Over a decade ago I worked at an insurance company that did this. The way it worked was that the C stood for the century that the company was founded, for example, 1=1800, 2=1900 and 3=2000. As for how to convert it, if you can convert it to a string then use a substring function to breaking it into individual parts that should do most of it. The final part is converting the century code. Hope this helps.