Height in feet and inches

[cothmer]

I have a string value for height in the database that I would like split out into feet and inches. For example the value right now is 66, 65, etc...

[former_member203168 · Accepted solution]

Hi Curt,

If Unit of measure is CM then use below logic

(totext(({Database_cm}* 0.0328084),0)) & " Fts   "&Tonumber((Split(totext({Database_.cm}* 0.032808,5),".")[2])) *0.00012 & " Inches"

If Unit of measure is in Meters then You need to convert meters to CM by using below formula

{Meters_field}/100

--Praveen G

[cothmer · Accepted solution]

thanks for your responses, I got it to work.

[abhilash_kumar]

Hi Curt,

What is the Unit of Measure for this field in the database currently? What does 65 mean - cm, m?

-Abhilash