1 Reply Latest reply: Dec 12, 2012 2:36 PM by Mayil Vahanan Ramasamy RSS

    Filtering a Load Table

      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)


      Resident vw_EOM_Sales_Leads_Metrics_Detai
      where Time_Month_Key = date(Now());