Custom Column to Category Triaging, Triaged or Late Returning an Error

[MartynHead]

My custom column is returning error based off a conditional column

Conditional Column

Code:

if [Triaging] = "Triaging" and [Triage Target] >= DateTimeZone.LocalNow() then "Triaging" else if [Triaging] = "Triaged" then "Triaged" else "Late"

This returns error for those in the triaging state

Triage Target is a custom column which is Start Date & Time & (04/24)

Any advise other than a replace Errors with Triaging?

[MartynHead]

hi @ovde 

I have changed it DateTime.LocalNow() and I get this error

Expression.Error: We cannot apply operator < to types DateTime and Text.
Details:
Operator=<
Left=05/06/2023 11:15:50
Right=2023-06-02T14:40:00Z

[MartynHead · Accepted solution]

Hi @ovde I have transformed the date format to match the left and it is fixed.

Thanks for your help.

[ovde]

Hi @MartynHead ,

Can you click on the error and tell us what is says? I suspect something is nog quite right with the DateTimeZone.LocalNow() function since your custom column is of the datetime type and not datetimezone. I suggest you use DateTime.LocalNow - PowerQuery M | Microsoft Learn