| 1 | if(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?
