STR([number 22.5]),2) +' Years '
+ str( round(([number 22.5]-floor([number 22.5]))*12,0)) +' Months'
where Number 22.5 is the years of service -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Perfect! This worked just the way I was wanting it too.
Thanks for the help Jim!
Final CF: left(STR([Years of Service]),2) +' Years '+ str( round(([Years of Service]-floor([Years of Service]))*12,0)) +' Months'