Unanswered

Calculate the difference of years between two dates.

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I'm asking for help how to calculate the difference of years between two dates. I need to create a flow that will calculate the work experience and send an e-mail on the anniversary day. The problem is that I only have to send an email when someone have 1, 5 or 10 years anniversary. The data will be on sharepoint or excel. At the moment my flow looks like this:
If anybody could give me some tips I will be very thankful.

Best regards
Konrad

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous Please create 3 calculated columns in SharePoint List and these columns will be based on Hire date.

Like FirstYearColumn would be = Hire Date + 365 day

Then fetch these column details in flow with condition you are using.

See more details about calculated columns- SharePoint Calculated Column formulas based on Date and Time | Gopenly

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

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Hardesh15 ,

thank you for answer. The question is right now how this solution will be working for leap year?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous I do not understand why you are focusing on leap year here?. Suppose i joined one organization today 23rd June 2022, So my next five year date will be 23rd June 2027.

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

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@Hardesh15 Thank you for answer again.
I was wrong, you have a right it's doesn't matter 🙂
So my sharepoint list is looking like on the screen. Could you give me some advice how to working with date and conditions to check whether someone have 1, 5 or 10 years anniversary?

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous Use condition in your flow as you were doing previously. This time you will compare FirstYearAniversay is equal to Today date.

Pls check your calculated column date format inflow otherwise condition will be false.

Use utcnow('yyyy-MM-dd') for today date.

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

@Hardesh /Gopenly.in

Was this reply helpful? Yes No