1 Reply Latest reply: Mar 2, 2013 4:07 AM by Nirav Bhimani RSS

    Month problem load from qvd

          1if(month(InvDate) = 2,floor(num(InvDate)),floor(num(MonthEnd(InvDate)))) as InvDate2,
         2 if(month(InvDate) = month(Now()),floor(num(InvDate)),floor(num(MonthEnd(InvDate)))) as FACTDATE,


      Above an extract from a qvd load.

      The second line works perfect.

      The first line keeps returning an error.


      All i want is manipulate the invdate if the month = 2 and day = 29 because of comparison of february 2013 versus february 2012.


      Why can't a check the month against a numeric value?