Changing text type to Date type

[Sherry1000]

Hi there
I used different methods but I could not get result:
these are the ways that I tried and failed:1locale
2 date.fromtext([datecolumnname]) in costumcolum