Skip to Content
0
May 23, 2020 at 07:24 PM

Conversion failed when converting the varchar value 'March 31' to data type int.

1476 Views Last edit May 26, 2020 at 11:06 AM 2 rev

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