Any idea to solve this? will it be better to change the tglabsen to DATE type?
You really should change the column to a DATE type.
Working with text fields for dates will only give you headaches!