Month problem load from qvd

[#1]

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?

[nirav_bhimani]

Hi,

try this

num(month(date#(MonthName,'MMM')))

Regards,

Nirav Bhimani