A combination of Views 3 and the Semantic Views module is usually enough for me.
Under extreme circumstances where i, when I want absolutely zero markup, e.g. to display a completely custom date, iI create my own tiny template for the field in question (choosing the right file to create using the Theme Information part of the View). In your template, the default is...
print $output;
...which print $output;
, which is completely useless. For my date example, i replaced that with...:
print my_pretty_date($row->{$field->aliases['field_date_value']} ,
$row->{$field->aliases['field_date_value2']}
);
That will let me run my custom date formatting function with dates in MySQL datetime format.
IMPORTANT: iI don't know if the $row$row
data is sanitisedare sanitized. HardIt is hard to find out too.