You’re offline. This is a read only version of the page.
Announcements
210
Hi Community, trying to figure out how to get years and months between two dates. I am using an entity to grab start date and end date. Then I want to create a flow that subtracts the dates to get me years and months. So I expect the bot to output a text string that says "The calculated years of experience is 10 years and 3 month(s).
PVA BOT questions:
My attempt at creating the flow:
This is what my compose action has but I know its not correct:
@Pstork1 Thank you that works great. Sorry Pstork1 to keep on doing this but one more question.
I also need to take this function and divided by 3. Basically we have a different way of calculating years for different positions. Some positions get the full credit but some positions if they have a certain experience we give them a partial credit which is divided by 3. Or a 3 for 1 credit. When I try to just add / 3 at the end the expression faults. How can I divide this by 3.
Because of the differing length of months its always going to be an approximation, but this setup works.
1) Calculate the number of Days between using DateDifference()
2) Calculate the number of years by dividing the result by 365 days/year
3) Calculate the number of months by using MOD() to get the remainder from #2 and divide by an average of 30 days/month.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
