cancel
Showing results for
Did you mean:
Impactful Individual

## How do I capture the current quarter

Hello and good morning,

I have a situation where I need to update a SharePoint list on a quarterly basis.

My first thought was to get the current quarter, easy enough -

I have a SharePoint column called "CurrQuarter"

So when an item is added to the list and my workflow runs, I want to add the current quarter to that item.
So what I attempted to do was create four conditions to update a variable that would hold the current quarter number value

If the first condition isnt met then do the next condition

And if the second condition isnt met then evaluate the third condition and so on.

The issue is that this doesnt work.
Some direction from the experts here would definately help this noobie greatly!

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Impactful Individual

Figured this out.
The data returned by the ForrmatDateTime function returns a zero in front of the value.
My conditions were not correct because I was evaluating the variable as a single digit versus 01.

Community Champion

@golfnutt82 this can be done using parallel branch

Condition - for Q1, numeric value equals to less than or equals to 3

Condition 1 - for Q2, numeric value greater than 3 but less than or equals to 6

and so on...

you need to add 2 more conditions for Q3, Q4

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

2 REPLIES 2
Impactful Individual

Figured this out.
The data returned by the ForrmatDateTime function returns a zero in front of the value.
My conditions were not correct because I was evaluating the variable as a single digit versus 01.

Community Champion

@golfnutt82 this can be done using parallel branch

Condition - for Q1, numeric value equals to less than or equals to 3

Condition 1 - for Q2, numeric value greater than 3 but less than or equals to 6

and so on...

you need to add 2 more conditions for Q3, Q4

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Announcements

#### Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.