hi i got this
if you see the first column is a date in the db but type = TEXT , im using a db from other system
in theory it should order by first OLD dates to new dates i got also the date range
AND (
{{ !(rangodefecha.value.start) }}
OR (
o.fechaproxima_llamada <= {{moment(rangodefecha.value.end).format('YYYY-MM-DD') }}
AND o.fechaproxima_llamada >= {{moment(rangodefecha.value.start).format('YYYY-MM-DD') }}
)
)
AND o.fechaproxima_llamada IS NOT NULL
ORDER BY
c.apellidos,
o.fechaproxima_llamada ASC NULLS FIRST,
idclave_nombre
and got this query
what im missing to make order correct and not like that without any order
when i try to change type to date it shows an error:
any ideas? @PeteTheHeat @victoria @ScottR @Tess