Hi meenac, I haven’t dealt with DB2 for 14 years but this is the way it was, and may help. The DB2 DATE function is intended to work with the DATE data type. The ISO format is the default that come with DB2, but the system installer can change these defaults. ISO format is YYYY-MM-DD e.g 2005-12-31. Assuming your system has not overriden the ISO, if you were able to move the field into a DATE field then you could use the CHAR function to specify the EUR or USA format. CHAR returns the date as a character string including delimiters e.g CHAR(your column name, EUR) = 31.12.2005 or CHAR(your column name, USA) = 12/31/2005. Hope that helps.