Set Analysis date filter

[shumailh]

Hi All,

I am trying to get the report date which is the last month end date i.e. '09/30/2010'. I put this value in the variable throught the same table where all the Month end date present. please see the below code.

Script:
CardMast_Active:
LOAD Report_NO, LoadDate_Active, LoadDay_Active, bal, AIF FROM [$(Outputpath)CardMast_Active.qvd] (qvd);

MinMaxDates:
load
 minstring(LoadDate_Active) as StartDate,
maxstring(LoadDate_Active) as ReportDate
resident CardMast_Active

// now get the values...
 let ReportDate = peek('ReportDate',0) ;

Expression:
=COUNT({$<AIF = {'P'}, LoadDate_Active = {$(=Date($(#=ReportDate),'MM/DD/YYYY'))} >} AIF)

The above expression is not working.. [:S] please help

[gandalfgray · Accepted solution]

Hi

Try adding a couple of " like this:

=COUNT({$<AIF = {'P'}, LoadDate_Active = {"=$(=Date($(#=ReportDate),'MM/DD/YYYY'))"} >} AIF)

[shumailh]

Good Man! u r such a help..cheers & Thanks

Shumail