>Hi Mike,
>
>My son come up with simpler expression. :)
SELECT ((MonthNum + (12 - @fystart)) % 12 + 1) AS RealMonth ...
>
SWEET! That's the kind of simplicity I was seeking!
Please thank your son for me!
Michael
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site