cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NurNina
Post Patron
Post Patron

How to get differences of two dates

Hi, I have a date field that I need to update based on differences between two dates. How do I do that in flow? 

 

I have Start Date and End Date.

I need to update the new field , Interim Date: End Date- Start Date.

2 REPLIES 2
poweractivate
Community Champion
Community Champion

@NurNina 

 

To do this in Microsoft Flow (currently called Power Automate) you can refer to the below where it has been answered:

 

how to get difference between two dates in flow 

 

If you meant Power Apps Canvas App instead:

 

For Canvas App:

 

Use the DateDiff function.

 

Example:

 

DateDiff( StartDateTime, EndDateTime [, Units ] )

  • StartDateTime - Required. Starting date/time value.
  • EndDateTime - Required. Ending date/time value.
  • Units - Optional. The type of Units to add: Milliseconds, Seconds, Minutes, Hours, Days, Months, Quarters, or Years. If not specified, Days are used.


 

@poweractivate put it in the update record is it? 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,059)