How to get Q1,Q2,Q3,Q4 for every three month

Help Studio
, ,
1

Hi Team,

how to get Q1,Q2,Q3,Q4 for every three months

Example: Jan,Feb,Mar ----Q1
Apr,May,Jun -----Q2
’
’
Like

Can any one help plesae

Thanks
Shaik

2

@shaik.muktharvalli1,

If you are trying to find from a date use ElseIf activity like this.

If inputDate.Month <= 3 Then
    quarter = "Q1"
ElseIf inputDate.Month <= 6 Then
    quarter = "Q2"
ElseIf inputDate.Month <= 9 Then
    quarter = "Q3"
Else
    quarter = "Q4"
End If
3

it depends on your input

When input is a datetime / parseable format

grafik
grafik336×152 14.5 KB

when input is different, then let us know the details

1 Like
4

DatePart ----variable?

5

is a method, which we can use:

6

@shaik.muktharvalli1
can the topic be finalized? So please mark the solving post
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum