Date formatting - Text to Date

[SenthilD]

Hello,

For a table, the input date is from a text is received as “dd/mm/yyyy”. As appsheet expect “mm/dd/yyyy” format, I’m using a text function as below.

TEXT (
MID([UID],FIND(“dob=”,[UID])+5,10) ,
“dd/mm/yyyy”
)

But its throwing a an exception saying that TEXT function with two arguments requires a temporal type and a format string

Please help.

Regards,
Senthil D