InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:57:56 GMT20http://www.teradata.com/teradataforum/Topic12405-9-1.aspxCOOL.. ThanksFri, 01 Aug 2008 13:15:21 GMTnewbie_123http://www.teradata.com/teradataforum/Topic12405-9-1.aspxSo add parentheses:CASE WHEN grp_prpkg_exp_dt = '9999-12-31' THEN (CAST('2007-12-31' AS DATE) - grp_prpkg_eff_dt MONTH(4)) ELSE (grp_prpkg_exp_dt - grp_prpkg_eff_dt MONTH(4)) END AS numFri, 01 Aug 2008 11:52:08 GMTFred Pluebellhttp://www.teradata.com/teradataforum/Topic12405-9-1.aspxIt gives me syntax error saying that END should be there between grp_prpkg_eff_dt and MONTHFri, 01 Aug 2008 10:46:07 GMTnewbie_123http://www.teradata.com/teradataforum/Topic12405-9-1.aspxHello,What error you are getting?Regards,AdeelThu, 31 Jul 2008 22:55:03 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic12405-9-1.aspxHello,The following statement works if it is just a selectselect case when grp_prpkg_exp_dt = '9999-12-31' then CAST('2007-12-31' AS DATE) - grp_prpkg_eff_dt else grp_prpkg_exp_dt - grp_prpkg_eff_dt end as num ,grp_prpkg_eff_dtfrom db_bidwd1v.dim_grp_prpkg_cvgsample 5but when I m trying to convert it to give me the number of months:select case when grp_prpkg_exp_dt = '9999-12-31' then CAST('2007-12-31' AS DATE) - grp_prpkg_eff_dt MONTH(4)else grp_prpkg_exp_dt - grp_prpkg_eff_dt MONTH(4) end as num ,grp_prpkg_eff_dt from db_bidwd1v.dim_grp_prpkg_cvgsample 5It gives me error.Can someone help me.Thanks in advance.Thu, 31 Jul 2008 14:21:45 GMTnewbie_123