AppGini Community Forums

How to calculate the interval of days between dates of the same table but of different records
This is my code but it doesn't work for me


SELECT ABS(DATEDIFF(FECHA, LAG(FECHA) OVER (ORDER BY FECHA))) FROM `Clientes`;
WHERE `Clientes`.`ID`='%ID%'



SELECT DATEDIFF( ( SELECT MIN(FECHA) FROM Clientes WHERE FECHA > ( SELECT FECHA FROM Clientes WHERE `Clientes`.`ID`='%ID%' ) ), ( SELECT FECHA FROM Clientes WHERE `Clientes`.`ID`='%ID%' ) ) AS date_diff FROM Clientes WHERE `Clientes`.`ID`='%ID%';

The code works perfectly. It was exactly what I needed

thank you for your valuable help...!!!!