Utility - Get Date and Time Difference

Overview

The 'Utility - Get Date and Time Difference' calculates the difference between the two dates and time values provided.

Video Guide

Get the difference between two date or datetime values in Power Automate

Credit Count

This is a Utility action and therefore consumes only 0.05 credits per operation (except 1 credit on the free plan). For example, 100 operations will consume 5 credits on a trial and all paid plans.

Default Parameters

The default 'Utility - Get Date and Time Difference' flow action parameters are detailed below:

  • Start Date: Start date (and optionally time) of the period to be calculated
  • End Date: End date (and optionally time) of the period to be calculated
  • Interval: he interval to calculate - Year, Quarter, Month, Week, Day, Hour, Minute, Second, Millisecond

Advanced Parameters

The advanced 'Utility - Get Date and Time Difference' flow action parameters are detailed below:

  • Days to Exclude: Specify the days to be excluded from the calculation as a comma-delimited list, for example: Saturday, Sunday
  • Culture Name: Set the culture used to process the date value provided. Please refer to the Culture Names article for a list of supported cultures.

Return Parameters

Action Specific Return Values

  • Result - The interval value

Standard Return Values

  • OperationId - The unique ID assigned to this operation.
  • HttpStatusCode - The HTTP Status code for the response.
  • HttpStatusMessage - The HTTP Status message for the response.
  • Errors - An array of error messages should an error occur.
  • Operation Status - Indicates whether the operation has been completed, has been queued or has failed.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk