Hi Mike,
parameter x
return allt(str(x)) + iif(x = 1, "st", iif(x = 2, "nd", iif(x = 3, "rd", "th")))
>Hi people!
>
>Anyone have a simple function to take a number and append the correct st, nd, rd or th? Its for a legal document "contract is made as of nth day of".
>
>Thanks
kenweber
GCom2 Solutions
Microsoft Certified Professional