Filtering a Load Table

[#1]

I am doing a load using the following script and would like to do further filtering based on one of the fields in the load. I am trying to only show data where the Time_Month_Key is equal to the Current Month

The Time_Month_Key is formatted as 'YYYYMM'

How would I write the filter to do this? (See Section in Red Below)

HierarchyLookup:
Load
'Business_Unit',
'Director',
'Manager',
'Rep',
'Reporting_Team',
'Time_Month_Key',
'VP'
Resident vw_EOM_Sales_Leads_Metrics_Detai
where Time_Month_Key = date(Now());

Thanks

Tim

[MayilVahanan]

HI

where Time_Month_Key = date(Now(),'YYYYMM');

because date(now()) gives DD/MM/YYYY default format. so as per your YYYYMM format, so must change the format..