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.
0 Comments