Hi Guys,
I have a problem here where i am trying to achieve the following in IDT:
Column : Quarter (data type numeric coming from backend sql server)
Custom Column C:Quarter Names:
Case when quarter='1' then 'March 31' else quarter END
but i am getting the error "Conversion failed when converting the varchar value 'March 31' to data type int."
I want that if the quarter is 1 then display March 31
2=June 30
3=Sept 30 etc....
Please help.
Thanks
Vaibhav