Hi all, can anyone advise how to convert months to quarters as described below. Jan, Feb, Mar = Q1 Apr, May, Jun = Q2 Jul, Aug, Sep = Q3 Oct, Nov, Dec = Q4 I want to save the file in a folder Q1 etc based on the month the report relates to. Thank you for your help. Jan

Hi, How about the following steps? First, define the following dictionary in advance. 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 dic…

Convert month to quarter

Help Studio

ppr (Peter Preuss) August 30, 2021, 12:50pm 6

3 Likes

Forum Engagement Daily Reports

Year Quarter Based on Month (MM)

Topic		Replies	Views
Get previous month out of New Dictionary when January Studio question	5	516	October 2, 2022
How Can I Assign Specific Quarters using Variables? Activities activities , question , script	6	896	December 22, 2021
How to check current date lies in which quarter? Studio studio , question , activities_panel	19	1805	July 7, 2022
How to get first month of previous quarter Studio uiautomation , activities , question	8	2650	February 1, 2022
How can I calculate a quarter of a year RPA Discussions coding , general	8	1870	March 8, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Convert month to quarter

Related Topics