Getting years between two dates

(0) Share

Report

Posted on by Sajarac

3,295

Hello community.

Sorry silly question here:

I need to get the number of years between the hire date and Today's date and the result should be in a single value. So no decimals. i.e. Seniority Employee A = 23 Years

BTW, The hire date value will be read from my data source "excel", and today's I am declaring the value in my flow via utcnow

Could someone point me in the right direction?

thanks in advance,

Regards

Categories:

General topics

All responses (11)

Answers (1)

Sort by

Verified answer

jinivthakkar 4,187 on at

Like
a
(1)

Report
Copy link

Link copied!

@sajarac

what i did - I took random dates, extracted the year part and did subtraction

Additionally, check this out which will help you in reading excel data and I already showed you how to get the difference in dates.

https://www.youtube.com/watch?v=F2leKcMPAtw&t=127s

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
jinivthakkar 4,187 on at

Like
a
(1)

Report
Copy link

Link copied!

@sajarac all of this can be achieved using one flow which reads excel row by row and gives you the difference. If you don't know just check out the link I gave or you will a lot of content on how to read excel using power automate.
Hope this helps.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your prompt response, I was totally lost. I was thinking that the compose function will be a single formula with a subtraction or something similar. Thanks again I will implement your solution.
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@sajarac Addition to @jinivthakkar solution.

If you want to minimize actions- you can use 'yyyy' in each date expression. it will give you only years. Example-Formatdatetime(utcnow(),'yyyy')==> 2021

adddays(utcnow(),2000,'yyyy)==>2026

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, sorry to bother you I have a couple of questions?

1. In my data source Y have the hire date in this format MM/dd/yyyy. And in your flow you have set as 'yyyy-MM-dd'. Can I change all the format or it affects the flow?

2. In the Initialize Variable 2, what does it means the number 2000?

3. In the Compose what does it means the "0,4" numbers?

Sorry silly questions but I would like to understand the formula applied.

Thanks in advance
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@sajarac 1. You can use any format. It does not impact your flow.

2. 2000 are number of days added in current time.

3. It is start and end index number of a string.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh
theresan 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I realize this post is 10 months old but was hoping for some help. When I implement your instructions, it always returns 6 years. I don't understand why you are adding 2000 days.
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@theresan This was expression to explain requirement. you can add number of days in current days as per your requirement.

adddays(utcnow(),2000,'yyyy) => you can change it to 365 and you will see next year as output. if i change this expression adddays(utcnow(),365,'yyyy-MM-dd') then you will find next year date.

hope it clears your doubt.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
theresan 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for my confusion but I am just not getting this. I have a spreadsheet which I use Get Items to access. I want to compare a date in that spreadsheet to today. It always says 6 years which I understand now that it is because you are adding 2000 days to todays date but the varHireDate variable you created needs to be my actual hire date. I can't figure out how to pull in my hire date as initialize variable in order to compare it.
gatorgirl1298 6 on at

Like
a
(0)

Report
Copy link

Link copied!

The example and solution provided are backwards for what I am looking to use this for. I want to take the date today in yyyy and subtract the Hire Date in yyyy. So the add days 2000 makes no sense to me. I have two dates that are static, and I need to find the difference between the dates. What am I missing?