A common request in my company is for dates to be expressed in relation to the Quarter of the year in which they fall. Using Power Automate there is no native way of calculating this, so in this post I’m demonstrating two different methods to calculate the Quarter from a given input date:
- Nested IF Conditions
- Filtered Array
Nested IF Conditions
1. Trigger Flow – for the…
Continue Reading ryanmaclean365’s Article on their blog
Calculate Quarter for a Date in Power Automate
A common request in my company is for dates to be expressed in relation to the Quarter of the year in which they fall. Using Power Automate there is no native way of calculating this, so in this post I’m demonstrating two different methods to calculate the Quarter from a given input date: 1.
Blog Syndicated with ryanmaclean365’s Permission
More About This Author
Array
Dyn365CE31 March 2021Finding Records Shared With a Specific Team or User
Dyn365CE14 October 2020Calculate Full Months between two dates with Power Automate
Dyn365CE3 August 2020Converting UTC Date Time to UNIX Time with Power Automate
Dyn365CE28 July 2020Converting Excel Date Time Serial Values With Power Automate
