Hi Guys I always have trouble in date calculation. Let’s an employee join a compay June 1, 2022. The total service years until the currnet date, today(), August 8, 2023 is June 1 , 2022 to June 1, 2023 - 1 year July 1, 2023 to July 31,2023 - 1 month August 1, 2023 to August 8, 2023 - 8 day…

Check this: <a name="p-510557-convert-birthdate-to-current-age-in-yearsmonths-f-google-cloud-communityhttpswwwgooglecloudcommunitycomgctips-tricksconvert-birthdate-to-current-age-in-years-months-formatm-p301175highlighttruem1705-1" class="anchor" href="#p-510557-convert-birthdate-to-current-age-in-yearsmonths-f-google-cloud-communityhttpswwwgooglecloudcommunitycomgctips-tricksconvert-birthdate-to-current-age-in-years-months-formatm-p301175highlighttruem1705-1"> Convert Birthdate to Current Age in Years/Months f… - Google Cloud Community The main issue is that there is no way to make an 100% accurate version of this, but it gets pretty close

Total Service Years (Year & Month)

AppSheet AppSheet Q&A

desmond_lee August 17, 2023, 12:11am 10

thank you. Very good discussion

Topic		Replies	Views
How to calculate days , month and year AppSheet Q&A expressions	3	4	November 2, 2020
How to Calculate Years, Months, Days elapsed from a certain date in AppSheet AppSheet Q&A ux , expressions	2	12	September 25, 2020
Convert Birthdate to Current Age in Years/Months format Tips & Tricks expressions	35	67	August 19, 2025

Total Service Years (Year & Month)

AI Suggested topics