Error filtering my records in PowerQuery to only select those records with due date <= todays date

[EaglesTony]

I am trying to filter my records to only select those records where the due date <= todays date.

I have the following:

= Table.SelectRows(#"Renamed Columns", each [DUE_DATE] <= DateTime.Date(DateTime.LocalNow))

However I am getting "Expression.Error: The DateTime.Date function expects and input of type DateTime or DateTimeZone"

My DUE_DATE field I change to type date.

[HotChilli · Accepted solution]

DateTime.LocalNow is a function so you need to call it with brackets, DateTime.LocalNow()