Quarter (Q1) need to place in subject line of email dynamically

[chaitanyaKumar]

Hi Community,

i had an issue with the email subject line need to update Q1,Q2 things according to the current month calculation.

Ex. if Month jan,feb,march - Q1
April,May,June - Q2.

can you please help on the flow design in assign activity. so that i can update in the email body.

Thanks and regards.

[ashokkarale]

@chaitanyaKumar

Use this logic

strQuarter = If(intMonth <= 3, "Q1", If(intMonth <= 6, "Q2", If(intMonth <= 9, "Q3", "Q4")))

[bharat.c (Bharat Chavda)]

Hello @chaitanyaKumar,

You can create a new dictionary variable of type string, string and assign these values to it.

dict = New Dictionary(Of String,String)From{{“Jan”,“Q1”},{“Feb”,“Q1”},{“Mar”,“Q1”},{“Apr”,“Q2”},{“May”,“Q2”},{“Jun”,“Q2”},{“Jul”,“Q3”},{“Aug”,“Q3”},{“Sep”,“Q3”},{“Oct”,“Q4”},{“Nov”,“Q4”},{“Dec”,“Q4”}}

Then you can simply make use of this below expression to find out Quarter.

dict(MonthName(today.month,true))

Regards,
Bharat

[sven.wullum1]

Hi!

You can use the “number” of the month and the knowledge that a quarter is divided into 3 months

“Q”+(((Now.Month - 1) \ 3) + 1).ToString

[chaitanyaKumar]

i am getting this error ashok

[ashokkarale]

@chaitanyaKumar,

Make sure strQuarter is of type String and intMonth is of Int32 datatype

[chaitanyaKumar]

yeah it worked, and have a smal doubt.

If(intMonth <= 3, “Q1”, If(intMonth <= 6, “Q2”, If(intMonth <= 9, “Q3”, “Q4”)))

as per this logic <=9 is not less than 9 then it default take Q4 or need to write logic on that.

[ashokkarale]

@chaitanyaKumar,

It’s already covered. Q4 will be returned only when these conditions will fail - intMonth <= 3, “Q1”, If(intMonth <= 6, “Q2”, If(intMonth <= 9, “Q3”

So need of additional logic. Cheers!

[chaitanyaKumar]

thanks ashok for simplifying things and taking your time. it worked.