Power Query Custom Step to filter table for second Monday of the month not working

[obriaincian]

Hi All,

I have created a custom step in Power Query to filter a table (table in Filtered Rows1) where the date created is teh second Monday of the month.

The issue is Power Query just colors the code red in the formula bar and outputs the code rather than a filtered table

let
    Source = #"Filtered Rows1",
    FirstDayOfMonth = Date.StartOfMonth(DateTime.LocalNow()), 
    FirstDayOfWeek = Date.StartOfWeek(FirstDayOfMonth, Day.Monday),
    SecondWeekStart = Date.AddDays(FirstDayOfWeek, 7),
    SecondWeekEnd = Date.AddDays(SecondWeekStart, 6),
    FilteredTable = Table.SelectRows(Source, each [Date created] >= SecondWeekStart and [Date created] <= SecondWeekEnd) 
in
    FilteredTable

[Ahmedx]

pls try this

let
    Source = Date,
     FirstDayOfMonth = Date.StartOfMonth(DateTime.LocalNow()), 
    FirstDayOfWeek = Date.StartOfWeek(FirstDayOfMonth, Day.Monday),
    SecondWeekStart = Date.From( Date.AddDays(FirstDayOfWeek, 7)),
    SecondWeekEnd = Date.From( Date.AddDays(SecondWeekStart, 6)),
 FilteredTable = Table.SelectRows(Source, each [Date created] >= SecondWeekStart and [Date created] <= SecondWeekEnd) 
in
    FilteredTable