web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Adding Days or Years b...
Power Apps
Unanswered

Adding Days or Years based on another field value

(0) ShareShare
ReportReport
Posted on by 48

A newbie here so grateful for any tips..

 

TENOR.png

 

  • Creating a simple flow that should add days (years) to a specific date field
  • The Tenor = decimal and will be the number of years added, so 1 year, 1,5 years, 2 years etc...
  • I attempted to add a second step, where the flow will calculate the Tenor*365 = the total amount of days added
  • I am using compose as variables won´t allow me in the for each so I am hoping for a simple: Due Date = Contract Date + number of days that is the resulting number from the Tenor*365

I am stuck at the final calculation as I believe this is a float, but I want to achieve the date calculation as:

addDays(outputs('Compose_contract_date'),outputs('Compose_Tenor_in_days'))

     Add Days                Contract Date          +             Resulting number of days (Tenor in days)

 

  1. The red part is where I am stuck. If adding a simple number then the formula is OK and I can see that I am halfway there, however, I want the value of the red as a number (float? as it can be decimal) and achieve the Contract Date + days resulting in the Tenor*365
  2. Am I correct in adding 365 and not 364? as reading some articles about leap and non-leap years

    Thank you
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard