Date format is MM/DD/CCYY where MM represents a two-digit month, DD represents a two-digit day of the month, CC represents a two-digit century, and YY represents a two-digit year. I am converting ISO PAIN 001 to EDI 820 and it uses ccyy format but when I convert it, it shows 20180719, means it is today's date. Is there any way to convert from DDMMYYYY(American Date Format) to DDMMCCYY by using any calculated fields? Your urgent response is. This may vary from database to database, but what does the following format mean and yield. Is there such a formatting? Is this different from YYYY? If there is a difference, who would generally use this format?. But they mean to write the year in a 4 digit format, so technically is yyyy.