topic Re: We cannot apply operator - to types Function and Date in Power Query

We cannot apply operator - to types Function and Date

Anonymous — Thu, 19 Aug 2021 19:18:08 GMT

Hi all...

I am trying to find the difference, in days, from today's date and a Report date. If the difference is greater than or equal to 60 days, produce a 1, else a 0. I am receiving a "We cannot apply operator - to types Function and Date" error with the expression below. The data type for Report Date is date, and I'm thinking the error has something to do with trying to compare a date/time field with a date field.

each if Duration.Days(DateTime.LocalNow - [Report Date]) >= 60 then 1 else 0

Kudos to anyone who can assist here.

Re: We cannot apply operator - to types Function and Date

mahoneypat — Thu, 19 Aug 2021 20:27:00 GMT

Please try this instead

each if Duration.TotalDays(Date.From(DateTime.LocalNow()) - [Date]) <=60 then 1 else 0

Pat

Re: We cannot apply operator - to types Function and Date

Anonymous — Thu, 19 Aug 2021 21:30:18 GMT

Great. Thank you! Looks like that converts the DateTime format to date at which point it can be compared to my Report Date column.