Operator < can not be applied to Date & DateTime

[hume]

Hi,

I get an error message when trying to use the Table.SelectRows function to get data for the last 365 days only. I have tried it in PowerQuery Excel first and it works fine. In PowerBi Desktop however I get an error message saying the operator < can not be applied to types Date and DateTime. My [Date1] column is DateTime. I use the DateTime.LocalNow function to get the current date. To get the current date - 365 days, I use the Date.AddYear function. I am afraid that this function converts DateTime to Date and thus causing the error. Is this correct ? And if so, how can I solve this? There don't seem to be DateTime functions to calculate dates. Thanks in advance.

[MarcelBeug]

Your Date1 column is of type datetime, which is the default for Excel date fields that are imported in Power Query.

The solution is to adjust your #"ChangedType" code and make sure Date1 is changed to date instead of datetime.

Date.AddYears doesn't convert datetime to date, but year a feeding Date.AddYears with a date from one of the DateTime functions that return dates: DateTime.Date.

You can use Date.AddYears for dates, datetimes and datetimezones; it will return the same data type as the data type of the input.