Syntax
if(?monthcode?='1')
then
(' January')
else if(?Report Period?='2')
then
(' February')
else if(?Report Period?='3')
then
(' March')
else if(?Report Period?='4')
then
(' April')
.
.
.
.
.
else if(?Report Period?='12')
then
(' December')
Case when syntax
case ?monthcode?
When 1 then 'Jan'
When 2 then 'Feb'
...
When 12 then 'Dec'
end
No comments:
Post a Comment