I am trying to use the "calculated fields" feature of the appgini software to concatenate two date fields.
Since the dates are stored in the English format I would also like to display them in the European format.
My table is called macro_eventi
The two date fields are called data_inizio and data_fine
I entered this query but it doesn't work.
Code: Select all
SELECT CONCAT (DATE_FORMAT(`macro_eventi`.`data_inizio`,`%d/%m/%Y`), DATE_FORMAT(`macro_eventi`.`data_fine`,`%d/%m/%Y`)) FROM `macro_eventi`
WHERE `macro_eventi`.`ma_ev_pri_key`='%ID%'
THANK YOU!!!
Fabiano