dateadd function does not work in Case

Question

1.00/5 (1 vote)

See more:

IF write RemaingPeriod = CASE WHEN 1 then CASE when type = 2 then dateadd(mm,12,getdqte())end
end what is wrong here

Posted 19-Jul-13 12:13pm

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PIEBALDconsult · Answer 1 · 2013-07-19T12:44:00

"CASE WHEN 1" seems silly and what do you want when type isn't 2?

Posted 19-Jul-13 12:44pm