Answered
Hello,
I have a field called HireDt that is formatted as date and mm/dd/yyyy. I want to compare HireDt with today's date and come up with YrsSvc calculated field with only the full years between.
Any help would be appreciated.
Thanks, Shawn
(edit: this will just show the difference in whole years, if you want to take the actual day into account it needs to be tweaked a bit)
- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com