How to get filtered data based on a date

[Mohan Gudimetta]

I have a date in 9th column, i want to get all the data rows who's date is before today's date. The filter is working but it is not returning the filtered data. 

I need to get ONLY the filtered to iterate through each row for further functionality.

How can i do that, can anyone please help me on this?

  MySheet.activate();

    if (MySheet.getDataRange().getFilter() != null)

      MySheet.getDataRange().getFilter().remove();

    

    var toFilter = MySheet.getDataRange();

    //var filter = toFilter.createFilter();

    var now = new Date();

    //Make some criteria to filter with.

    var fcb = SpreadsheetApp.newFilterCriteria();

    fcb.whenDateBefore(now);

    filter.setColumnFilterCriteria(9, fcb.build());

    

    var Mydata = MySheet.getRange();