We cannot apply operator - to types Function and Date

Question

Hi all...&nbsp;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]) &gt;= 60 then 1 else 0&nbsp;Kudos to anyone who can assist here.

mahoneypat · Accepted Answer

Please try this instead
&nbsp;
each if Duration.TotalDays(Date.From(DateTime.LocalNow()) - [Date]) &lt;=60 then 1 else 0
&nbsp;
Pat
&nbsp;

Forum Discussion

We cannot apply operator - to types Function and Date

2 Replies

Related content

SQL Operator with multiple destinations

Use Wildcard Operator

DATESYTD function

Question mark as operator

Arithmetic Operation Overflow