Date formatting in a report

Hi,
To do it from within MVD, change your 'reportsql' as follows, using the 'strftime' function

SELECT
  person.lastname AS "person.lastname",
  person.name AS "person.name",
  strftime('%d/%m/%Y',holiday.holidaystart) AS "holiday.start",   
  strftime('%d/%m/%Y',holiday.holidayend) AS "holiday.end",
  person.id
FROM person
LEFT OUTER JOIN holiday ON person.id=holiday.id_person
WHERE person.id = $id  

I also changed 2 field names in your 'holiday' table from 'start' to 'holidaystart' and 'end' to 'holidayend'.  Try to avoid using field names that could clash with reserved words (such as 'end') that are used in scripts, sqlqueries or reportqueries.

Hi Fabio,
When you use 'select' (in a script, an sqlquery or a reportsql) you are retrieving data that is stored in various tables.  But calculated fields are never stored in any tables - they are just the result of temporary calculations you make when the program runs. 
Therefore, you cannot directly reference a calculated field in any 'select' statement.
What you need to do in this instance is simply write the same code that you have written for the calculated field in your reportsql (but be aware that occasionally there might be slight differences in syntax between calculated fields and 'select' statements).
Derek.

In FastReport, you need to tell the 'group header' what field you want to group by (see the screenshot in the attachment);  you could use 'lastname' but I tend to use 'id'.
Derek.