How to identify the year in Q1'21 as 2021?

Hi Team

I have a data like Q1’21 in an excel. I have to compare if it is current year i.e 2021. How to put the logic so that bot will know Q1’21 year is 2021 ?

give a try on detecting year with a regex
Simple One:

more specific:


You can use contains method of string.

suppose, you have string variable str that have value Q1’21,

if str.contains(21) {
do u wanna

or go with @ppr’s way.



Import System.Globalization namespace and then try the below code.


Thanks @sarathi125
Its giving the result as 2021.

Hi @sarathi125

Similarly can we also do for Jan’21. How can we identify if this is first month ?


Try this, it will work for both values Q1’21 and Jan’21


No I was asking for month not year. It should identify Jan means first month. Like it outputs Now.Month.

But as of now I am handling it through If condition.


Try with the following code, but always the Month name you are passing should have 3 letters.

DateTime.ParseExact("Aug'21".Split("'"c)(0), "MMM", CultureInfo.CurrentCulture ).Month.ToString

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.