SOLVED
Calculate years and months in given Datedif
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mlim0806
7 - Meteor
‎08-29-2022
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Community,
I have a newly created column "Time in Position" that is using datetimediff to calculate months inbetween date field and today's date. How would I change this to show years and months with labels included?
Example:
Output = 17
Desired Output= 1 year, 5 months
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
3 REPLIES 3
chuckleswk
11 - Bolide
‎08-29-2022
11:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎08-29-2022
03:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-30-2022
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, both soluations worked!
