How to Compare two date(Pls help Anyone)

Thu, 29 Mar 2012 14:10:34 GMT

Hi,

Can Anyone Help me on below Expression Please do the needful????

Kindly help me how to compare two date:

----------------------------------------------------------------------------------------------------------------------

Example:

let vCurrMonthYear=MonthName(Today());

LOAD RES_ID,
RES_NAME,
month(Date) as MonthName

FROM
(biff, embedded labels, table is Sheet1$);

IF(vMonth=MonthName) then

STORE ResourceFile INTO E:\ResourceFile.qvd (QVD);

Else

STORE ResourceFile INTO E:\Resourcee.qvd (QVD);

Endif

----------------------------------------------------------------------------------------------------------------------

After compare vMonth=MonthName, MonthName giving me Null Values.

in Monthname not carry value.

Kindly help me.

Regards

Ravi

How to Compare two date

Thu, 29 Mar 2012 17:22:08 GMT

Monthname is not a variable.

If you want to use it as a variable you should define it using the fieldValue function.