Month problem load from qvd

Sat, 02 Mar 2013 05:56:53 GMT

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?

Re: Month problem load from qvd

nirav_bhimani — Sat, 02 Mar 2013 09:07:12 GMT

Hi,

try this

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

Regards,

Nirav Bhimani