How to get the previous quarter as per Indian Financial year?

Help Activities
, ,
1

Hello All,

I need to get the previous quarter of the current financial year as below:

–>I need to get the first quarter in the form of Q1( between the months July to September)
–>I need to get the second quarter in the form of Q2( between the months October to December)
–>I need to get the third quarter in the form of Q3(between the months Jan to march)
–>I need to get the four quarter in the form of Q4((between the months April to June).

Please help on this

Forum Engagement Daily Reports
2

@naveen.s,

Use this in assign activity

previousQuarter = If(DateTime.Now.Month >= 4 AndAlso DateTime.Now.Month <= 6, "Q3",
                    If(DateTime.Now.Month >= 7 AndAlso DateTime.Now.Month <= 9, "Q4",
                    If(DateTime.Now.Month >= 10 AndAlso DateTime.Now.Month <= 12, "Q1", "Q2")))
3

@naveen.s

this should do the job

If({1,2,3}.contains(Now.Month),"Q3",If({4,5,6}.contains(Now.Month),"Q4",If({7,8,9}.contains(Now.Month),"Q2","Q1")))

image
image472×145 3.26 KB

cheers

4

@naveen.s,

My bad it’s returning previous to previous quarter. Here is revised logic to get last quarter.

previousQuarter = If(DateTime.Now.Month >= 4 AndAlso DateTime.Now.Month <= 6, "Q4",If(DateTime.Now.Month >= 7 AndAlso DateTime.Now.Month <= 9, "Q1", If(DateTime.Now.Month >= 10 AndAlso DateTime.Now.Month <= 12, "Q2", "Q3")))

image
image504×185 3.48 KB

1 Like
5

Thanks also I want get the year as well as below:
Q1 2024
Q2 2024
Q3 2024
Q4 2025
A single Space between (Quarter and Year)

6

@naveen.s

use this

If({1,2,3}.contains(Now.Month),"Q3 " + Now.Year.ToString,If({4,5,6}.contains(Now.Month),"Q4 " + Now.Year.ToString,If({7,8,9}.contains(Now.Month),"Q2 " + Now.Year.ToString,"Q1 " + Now.addyears(1).Year.ToString)))

basically now.addyears(-1).year will give previous year
now.year will give current
now.addyears(1).year will give next year

adjust the year if you need

cheers

8

@naveen.s

Can you please use the above one

Or you need to complete it like this

dateprevquarterdate + If((datePrevQuarterDate).Contains("Q1"), now.ToString("yyyy"),now.addyears(-1).ToString("yyyy"))

This gives Q1 2025 or Q2 2024 or Q3 2024 or Q4 2024

Cheers

1 Like