Today() and the load

[leocattqv]

Merry Christmas everyone,

I am needing to create a calculated field that will give me late and ontime.  this is what I have but I am getting syntax errors.

Any suggestions?

IF

([AUDIT_DUE] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"}>}'On Time', 'Overdue') as [On Time],

[Gysbert_Wassenaar · Accepted solution]

You cannot use set analysis in the script. So [AUDIT_DUE] = {"<=$(=Date(Today(),'MM/DD/YYYY'))"}>} is meaningless in the script. It's also not correct when used in an aggregation function in a chart expression.

Try instead: if([AUDIT_DUE] <= today(), 'On Time', 'Overdue') as [On Time]

[cheburashka]

Hello Leo,

Don't forget to mark answers as helpful or correct.

Thanks for sharing the solution you found and closing the discussion.

,KR Koen

[leocattqv]

That did it.

thank you