Gantt chart date conversion problem

Ignition
1

I have bind the Gantt chart data property to this sql query (SQL server 2014)

SELECT nom,date_debut,date_fin,avancement
FROM gmao_evenement
WHERE centraleid={gmao.CentraleID}

where date_debut and date_fin are sql server DATE columns
and I have a Java date conversion error ‘Gantt chart data incorrect. Second column must be a Date (StartDate)’

I have tried this :

SELECT nom,format(date_debut,‘dd/MM/yyyy’,‘en-US’) as date_debut,format(date_fin,‘dd/MM/yyyy’,‘en-US’) as date_fin,avancement
FROM gmao_evenement
WHERE centraleid={gmao.CentraleID}

but I have the same error.

How can I do ?

2

I have found the problem, I must convert my DATE columns to DATETIME columns like thet:

SELECT nom,
convert(datetime,date_debut),
convert(datetime,date_fin),
avancement
FROM gmao_evenement
WHERE centraleid={gmao.CentraleID}

and now it works !