How fix date order correctly

💬 Queries and Resources
1

hi i got this

image
image1138×728 103 KB

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:

image
image1167×646 61.1 KB

any ideas? @PeteTheHeat @victoria @ScottR @Tess