How to get Quarters from Date in Canvas PowerApps

[rampprakash]

Implementation Steps:

1. Navigate to https://make.powerapps.com

2. Select Apps --> Select New App --> Select Canvas

3. Once Page Opened Input the name and Select Tablet or Phone depends on your requirement, from my end am selecting Tablet Mode

4. Once Page Get Opened  --> Add a Label by Selecting (Insert --> Label) and Add a Button as Well

5. Now Select the Button and go to OnSelect and Write below code Logic

Code For Converting Date to Quarter

If(
    Month(Now())<=3,
        Set(getQuarterFromDate,"1"),
    Month(Now())>=04 && Month(Now())<=06,
        Set(getQuarterFromDate,"2"),
    Month(Now())>=07 && Month(Now())<=09,
        Set(getQuarterFromDate,"3"),
    Month(Now())>=10,
        Set(getQuarterFromDate,"4")
)

6. Now Set the Default Value to getQuarterFromDate

7. Now Click on the Button

You will see the Current Quarter Value there.

That's it 🙂

[Anonymous]

Can I make a suggestion? You could simplify your formula with the following:

Set(getQuarterFromDate, RoundUp(Month(Now()) / 3, 0))

This will divide the current month by the number of months in a quarter (3) and round up that value to the nearest whole number.

Thanks.