9 Replies Latest reply: Feb 12, 2010 1:50 PM by Julie Stephens RSS

    Help with Lookup() function

      I'm having problems with the Lookup function.

      In my load script, I've declared a variable that holds a date:

      SET vLatestPOSDate = Date(CurrentPOSWk)

      Now, I would like to use vLatestPOSDate to perform a table lookup. I have a table named 'FiscalCalendarFinal' that has a field called 'FiscCalEndDate'. So here's my lookup function:

      SET vCurrentQtr = Lookup('FiscCalQtr', 'FiscCalEndDate', $(vLatestPOSDate), 'FiscalCalendarFinal');

      vCurrentQtr returns no value. Am I using this function correctly? Why isn't it returning a value?