Number to Date in app formula

Hi, I have this String

(3579-3214/44637^44562|$123456)

,From here I'am Extracting the number Between "/"and "^".  by Using
(mid([scan QR],find("/",[Scan QR])+1,find("^",[Scan QR])-find("/",[scan QR])-1)),
and the Output is Coming As 44637  I want this to be in date "17/03/2022" Can Anyone help with this App formula.  

Solved Solved
0 5 145
2 ACCEPTED SOLUTIONS

"1/1/1900" + 44637

View solution in original post

Column  type date is not accepting here?

View solution in original post

5 REPLIES 5

"1/1/1900" + 44637

Awesome thanks a lot...

Column  type date is not accepting here?

sorted thank you.

@Marc_Dillon Thank you!

Top Labels in this Space