Text to Date

[My_Rebecca]

Text: 2023.06.25

How to turn to date format?

[Gabbar · Accepted solution]

please use Date# like, if that is the format of your text date in a field named Field_Text try:-

Load: 
Date(Date#(Field_Text,'YYYY.MM.DD')) as Field_Date 
from source;