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.

Example Flow

Please refer to the following article:

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

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.