Let command

[#1]

I have a qlikview script which has worked for years, but suddenly in the last two weeks it's stopped working. I have determined for some reason the script doesn't want to pick up the variable for the where field, and is coming back with "field not found". I am currently using Qlikview 10. Any idea's on how I can fix this.

If I remove the where clause it works fine, but off course my report is broken then.

Thanks.

Latest_Stock_Date:
LOAD

MAX([_Stock Date]) as [LatestDate]

RESIDENT Stock_Data2;

LET vQVDHistoryDate = fieldValue('LatestDate',1)-1;

// %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//
// Load all (historic) data prior to the above date from the QVD file.  This goes into the Stocks_and_Orders table...
//
// %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Stocks_and_Orders:
LOAD

[Plant],
[Storage Location],
[Material Number],
[Stock Date],
[Stock Level],
[Order Date],
[Order Quantity]

FROM Traceability.qvd (qvd) WHERE [Stock Date]<=$(vQVDHistoryDate);

[#2]

Please check the date format below script

Load Max([_Stock Date]) as [LatestDate] Resident Stock_Date2;

Regards,

Venkat Reddy

[#3]

In order to prevent confusion i use a number to represent the date, in this case its 41001.

[#4]

Same script i am running in QV 9.0.It's Working fine and  variable store the Date in number format.