How to compare date with a function? Help me please.

[Anonymous]

Can someone help me? I inserted the following function:

if [Status] = "in progress" and [Actual End] = null and [Scheduled End]> = Date.IsInCurrentDay then "3" else
if [Real Start] = null and [Programmed End]> = Date.IsInCurrentDay then "1" else
if [Actual End] <= Date.IsInCurrentDay and [Actual End] <= [Scheduled End] and [Actual End] <> null then "1" else "2"

I get the following message: Expression.Error: We were unable to apply the <operator to the Function and Date types.
Details:
     Operator = <
     Left = [Function]
     Right = 08/29/2019

Can someone help me?

[FrankAT]

Hi @Anonymous ,

your query fails because of the missing arguments in function Date.IsInCurrentDay.

Syntax is: Date.IsInCurrentDay(datetime as any) as nullable logical.

Example: Date.IsInCurrentDay(DateTime.FixedLocalNow())

Regards FrankAT

[Anonymous]

Frank and community,

Your help made me realize that this function returns "True" and when compared to the date column the error happens again, because the <operator cannot be applied to the Logical and Date types. Can you help me with a function that shows the current date and I can compare it with date columns, to establish criteria such as "Late", for example. Need me to be more clear? I appreciate the support so far.