Text to date

[Aditeeraipurkar1]

Need to convert  field  from text format to date :

Existing field format- Date |05/23/2022

I have tried all Date, Date #,Num, Num #,Right Subfield functions but nothing is working.Kindly help

[Almen]

try this:

makedate(subfield(date,'/',3),subfield(date,'/',1),subfield(date,'/',2))

[Tzvibe]

=Date(Date#(Right(YourDateField,10),'MM/DD/YYYY'),'MM/DD/YYYY')