report with date field as MM/DD/YYYY HH:SS

[cesar]

hello
i need a report with some fields type "date" but with the format, MM/DD/YYYY HH:SS. is it possible? I think that it is a g_complete_date_format, but i do not know what is necessary modify.
thanks
Cesar

[El_Greg]

Hi,

You have to go in config default inc and change the date format for the line you are exporting.
I did that to convert it from english to french format and it works fine...
mm-dd-yyyy to dd-mm-yyyy

See the changes I've done :

# --- date format settings --------
# date format strings (default is 'US' formatting)
# go to http://www.php.net/manual/en/function.date.php
# for detailed instructions on date formatting

# initial values
# $g_short_date_format = 'm-d-y';
# $g_normal_date_format = 'm-d-y H:i';
# $g_complete_date_format = 'm-d-Y H:i T';

# French format
$g_short_date_format = 'd-m-y';
$g_normal_date_format = 'd-m-y H:i';
$g_complete_date_format = 'd-m-Y H:i T';

Hope it helps.

Greg