Problema con consultas DateDiff

[[enecumene]]

Bueno al parecer por el momento resolvi el problema cambiando una pequeña parte del codigo:

Código SQL [-]
SELECT casa, factura, condicion, vence, occo, comentario, valor, recibo, fecha, detalle, dpto, status, datediff(fecha, curdate()),
CASE WHEN datediff(Curdate( ), fecha)
BETWEEN 0 <--AQUI
AND 15    <--Y AQUI
THEN valor
ELSE 0
END AS dias15,
CASE WHEN datediff(Curdate( ), fecha )
BETWEEN 16
AND 30
THEN VALOR
ELSE 0
END AS dias30,
CASE WHEN datediff(Curdate( ), fecha)
BETWEEN 31
AND 45
THEN VALOR
ELSE 0
END AS dias45,
CASE WHEN datediff(Curdate( ), fecha)
BETWEEN 46
AND 60
THEN VALOR
ELSE 0
END AS dias60,
CASE WHEN datediff(Curdate( ), fecha)
BETWEEN 61
AND 90
THEN VALOR
ELSE 0
END AS dias90,
CASE WHEN datediff(Curdate( ), fecha)  > 90
THEN VALOR
ELSE 0
END AS mas90
FROM fondo where status = 'DEUDA' and condicion = 'Credito' order by fecha asc

Mañana veremos que sucede.

Saludos.