Utility - Calculate Date

Overview

The 'Utility - Calculate Date' utility action for Power Automate adds or subtracts date and time values from a start date provided.

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.

Parameters

The default 'Utility - Calculate Date' flow action parameters are detailed below:

  • Date: Starting date and time value
  • Measurement: Set the time measurement used for the calculation (Ticks, Milliseconds, Seconds, Minutes, Hours, Days, Months and Years)
  • Operation: Set the operation type, either add or subtract
  • Interval: Set amount of time to add or subtract from the 'Date' value provided

Advanced Parameters

The advanced 'Utility - Calculate Date' 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
  • Dates to Exclude: Specify the dates to be excluded from the calculation as a comma-delimited list, for example: 25/12/2024,26/12/2024
  • 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 formatted date as a string

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