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'
Follow up question, for years of service under 1 year (i.e. 0.67 years) when I run the calc it gives my 0 years and 8 months, which is correct; but is there a TRIM function that I could put in the calc to trim out the 0 years part and only return the 8 months part?
thanks again for all your help!