Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a way to convert a YRMON string (ex. 202109 or 202005) into quarters.
So if Right(YRMON, 2)>9,4 should print '4' for any 4th quarter month - but I'm having trouble nesting the statements to mimic a CASE statement.
Any help would be appreciated,
Thanks.
Hi, you don't really need a case or nested if, to get the quarter you can use something like:
Ceil(Right(YRMON,2)/3)
Hi, you don't really need a case or nested if, to get the quarter you can use something like:
Ceil(Right(YRMON,2)/3)
Perfect, this is exactly the kind of solution I was looking for! Thank you!