I am attempting to capture the last date (max) in a dataset using a filter.  This is a date field.

I am attempting to pass a token from q "CurrentWeek_Period" to filter Q_CW and another Q_LW (not provided).  Received "unknown Token for "CurrentWeek_Period" so how does one pass filter values from one data strem into another?
q = load "Relative_Salesforce_Lead";
q = filter q by date('CreatedDate_Year', 'CreatedDate_Month', 'CreatedDate_Day') in [dateRange([2017,10,16], [2017,10,16])];
q = group q by 'CreatedDate2.Week_Override';
q = foreach q generate 'CreatedDate2.Week_Override' as 'CurrWeek_Period';
q_CW = load "Relative_Salesforce_Lead";
q_CW = filter q_CW by 'CreatedDate2.Week_Override' == 'CurrWeek_Period';

I am attempting to capture the last date (max) in a dataset using a filter.  This is a date field.