web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate calculate years from j...

Power Automate

Answered

calculate years from joining date

(0) Share

Report

Report

Posted on by syhrh

997 Super User 2024 Season 1

Hi, I'm trying to get Year of Service based on the Joining Date of an employee. I followed a youtube video and managed to get the total days from the joining date until the present day. I want years instead of days. How to do that? Do I need to divide days into months then years?

this is my flow to get the total days

Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,801 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @syhrh,

You could convert the present day and the joiner day to ticks and calculate the difference by using a sub function. You can div the result by 315,360,000,000,000 which is the amount of ticks in a non-leap year:

https://docs.microsoft.com/en-us/dotnet/api/system.datetimeoffset.addticks?view=net-6.0#remarks

Below is an example of that approach.

1. A SharePoint list with a Joiner Date column

2. The flow with a Get Items and a Select action.

The Years working key uses the following expression as a value:

div(sub(ticks(utcNow()), ticks(item()?['JoinerDate'])), 315360000000000)

The output will look like below.

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus It works, thank you!

Was this reply helpful? Yes No

Join the conversation