Create a new column on if statement(Very basic support needed)

[Anonymous]

Hi im trying the most simple query. Any help?

if ([Actual End Date] < [Target End Date])
    then 1
        else 0

If date1 is less then date2 then put 1 in the column otherwise put 0.
Error: Expression.Error: We cannot convert the value null to type Logical.
Support? 

[CNENFRNL · Accepted solution]

if ([Actual End Date] ?? #date(1,1,1)) < ([Target End Date] ?? #date(1,1,1)) then 1 else 0

[Anonymous]

Hi thanks for answering. I need to do the same thing but replace [Actual End Date] with Today() or something which works simular:

if (DateTime.Now() < ([Target End Date] ?? #date(1,1,1)) then 1 else 0

 Something simular to above should work. Any support?

[Anonymous]

if (DateTime.LocalNow() <...

--Nate

[Anonymous]

Ahh never thought to use the ?? In an if comparison--very cool.

--Nate

[Anonymous]

You have a null in one of your date fields,  so null > date isn't valid. Try each if is null [Actual End Date] or [Actual End Date] < [Target End Date] then 1 else 0

--Nate

[KeyurPatel14]

I have tried on this dummy data and it is working as per your requirement.
I added one custom column with the formula mentioned below:

Try this and if my solution solves your doubt then please consider it as a solution.

[Einomi]

Hi @Anonymous 

We need more info, I did a test on a simple dataset and it works...send us more code

[6677028]

It is very difficult for someone to help you in this case. if only this formula is not wrong. but it is used with many other formulas to know where is wrong.