How fix date order correctly

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