How to extract the quarter month name which belongs current month

Help
1

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…!

1 Like
2

Hi @naveen.srivastwa,

Use below code to get the current quarter.
date → datetime variable.

date=DateTime.Now()

(date.Month - 1) / 3 + 1

So based on the current quarter number you can get the name also.

Regards,
Arivu

3

Hello @naveen.srivastwa

You can use below line to get current quarter…

CInt(Math.Ceiling(Now.Month/3))

Thanks,
Navneet
Happy Automation! :slight_smile:

3 Likes
4

@NavneetPanpaliya

Thanks Buddy Your Code Helped me

5

Hi,

How would I convert quarter number from this expression to tell me the name of the month i.e what month is quarter 3?

Thanks

6

Hi i have list of months data where it contains month name from that i need to take out only current Quarter month date

for example to take out current month data i use in filter as = Now.Tostring(“MM”) so it gives me like Oct, Now i want current Quarter month name