> In case that the field is in date format, it return a string '2002-10-10 > 00:00:00'. > I want to change the format for '10/10/02'. You can use gsub: conv_date = gsub(db_date, "^(%d+)%-(%d+)%-(%d+).*$", "%3/%2/%1") Tomas