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! Go to Solution.
"1/1/1900" + 44637
Column type date is not accepting here?
"1/1/1900" + 44637
Awesome thanks a lot...
Column type date is not accepting here?
sorted thank you.
@Marc_Dillon Thank you!
User | Count |
---|---|
25 | |
24 | |
24 | |
23 | |
16 |