date-time format change in Report

[Jan Bastiaanssen]

How can i change the date-time format in the Last Modified Date column as in the Death Date column in this report ?

Thanks, Jan

[Rob Severijns]

Jan,

In Setup >> Configuration >> General Settings>>Miscellaneous I have set the Numeric Date Preference to:

My test report looks like this:

 

Maybe that helps.

Rob

 

[Jan Bastiaanssen]

Thanks Rob,

I don't get it, tried to do settings-option again with no result.

Checked my gedcom, is ok.

So i will look into my database, possibly there might be something wrong.

Jan

 

[Rob Severijns]

Jan,

For what it's worth here's my SQL statement:

 

SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname,firstname,altbirthdate,DATE_FORMAT(tng_people.changedate,'%d %b %Y') as changedate_disp, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (lastname = "Keulen") AND tng_people.gedcom = "Sev1" ORDER BY changedate

 

Rob

[Jan Bastiaanssen]

Many thanks Rob,

DATE_FORMAT(tng_people.changedate,'%d %b %Y') as changedate_disp

That gave me the solution.

Thanks a lot

Jan

[Rob Severijns]

Glad to be of help