Regex for fiscal year

[Prvn1]

What would be the regex for validating a fiscal year ?

ex: Q2FY24 or q2fy24

[AlpUtkuM]

https://www.servicenow.com/community/developer-articles/common-regular-expressions-and-cheat-sheet/t...

https://docs.servicenow.com/bundle/vancouver-servicenow-platform/page/product/service-catalog-manage...

[Sandeep Rajput]

@Prvn1 Here is the Regex to validate the fiscal year.

^Q[1-4]FY[0-9][0-9]$|q[1-4]fy[0-9][0-9]$

Please mark this answer helpful and correct if it address your requirement.

[SN_Learn]

Hi @Prvn1 ,

One of the Regex codes for the fiscal year validation is as below:

var pattern = /^[Qq][1-4]FY\d{2}$/i;

function validateFiscalYear(fiscalYear) {
return pattern.test(fiscalYear);
}

var fiscalYearToValidate = "Q4FY20"; // Replace with the fiscal year you want to check

if (validateFiscalYear(fiscalYearToValidate)) {
gs.info(fiscalYearToValidate + " is a valid fiscal year.");
} else {
gs.info(fiscalYearToValidate + " is not a valid fiscal year.");
}

[Amit Gujarathi]

HI @Prvn1 ,
I trust you are doing great.
Please find the below regex for the same :

^[Qq][1-4][Ff][Yy]\d{2}$