How can I calculate a quarter of a year

[Waleed_Albariqi]

i need help guys i want when i run the code in Apr for example i want the date to be 31/03/yyyy
or like i run the program in Jul the date will be 30/06/yyyy

[Srini84 (Srinivas)]

@Waleed_Albariqi

Check below for your reference

How to extract the quarter month name which belongs current month

Hi Folks, i need to calculate the quarter month name for current month. i.e. i have 4 quarter month Jan, April,July,October If current month is December then the input should be October If current month is October then the input should be July if current month is august the input will go to july. Please guide me. If possible pls provide sample xaml. Thanks…!

Hope this will help you

Thanks

[suraj.setty]

Hi @Waleed_Albariqi

Please use “datetime.now.month” which provides the current month , based on that you can have the dates accordingly.

[Waleed_Albariqi]

well guys i want also the last date

[Waleed_Albariqi]

not just the month

[Gokul001 (Gokul Balaji)]

Hi @Waleed_Albariqi

Have a look on the thread

How to take previous quarter in uipath

@brindhaS Create a workflow with two arguments, outPrevQuarterStartDate and outPrevQuarterEndDate with datetime datatype Get previous quarter date based on current date datePrevQuarterDate = DateTime.Now.AddMonths(-3) Find previous quarter number intPrevQuarterNumber = Convert.ToInt16((datePrevQuarterDate.Month - 1)/3+1) Find start date of prev quarter outPrevQuarterStartDate = new DateTime(datePrevQuarterDate.Year, (intPrevQuarterNumber-1)*3+1,1) Find end date of prev quarter outPrevQuar…

Regards
Gokul

[Waleed_Albariqi]

31/03/yyyy
30/06/yyyy
30/09/yyyy
31/12/yyyy
when i run it in first quarter the date should be 31/03/yyyy
and so on

[Waleed_Albariqi]

can you plz send me the code

[kadir.kilincarslan]

Hi,

do a switch case:

Case1:
(Now.Month/3)<=1
Then
“31/03/” + Now.Year.ToString

Case2:
1<(Now.Month/3)<=2
Then
“30/06/” + Now.Year.ToString

Case3:
2<(Now.Month/3)<=3
Then
“30/09/” + Now.Year.ToString

Case4:
3<(Now.Month/3)<=4
Then
“30/12/” + Now.Year.ToString

Regards