Power Query change column format based on keyword match in Header

[brawnystaff]

I am using the M code below to search for column headers that have the word "Date" in them and change the column data type to date.

However, the keyword search is case sensitive. Is there a way to make this case insensitive? Thanks.

Change =  Table.TransformColumnTypes(RenameHeaders, List.Transform(List.FindText(Table.ColumnNames(RenameHeaders), "Date"), each {_, type date})),

 

[JGordon11]

    DateColumns = List.Select(Table.ColumnNames(RenameHeaders), each Text.Contains(_, "Date", Comparer.OrdinalIgnoreCase)),
    Change =  Table.TransformColumnTypes(RenameHeaders, List.Transform(DateColumns, each {_, type date}))

 

[brawnystaff]

Thanks JGordon11. That worked.