How to Compare two date(Pls help Anyone)

[#1]

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

[#2]

Monthname is not a variable.

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