Date formula not working correctly

Buster Davis

So I have the following formula

=IF(AND(GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")

And my result is showing # Unparsable.

What is wrong with my formula these are date columns.

Thank you

Genevieve P.

Hey @Buster Davis

Can you double check that both of your columns are set as Date Type? We can see that the Go Live Date is a Date column, so can you check that the "Actual End" column is set as Date?

I would also suggest checking to see if the Actual End is not blank versus not being 0, since a Date won't ever be 0.

=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> ""), "On-Time", "Exceeded")

Kleerfyre

Missing a bracket in front of GO.

Kelly P.

@Buster Davis

You are missing a bracket on the GO Live Date reference.

=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")

Hope this helps!

Buster Davis

With the correction of the missing bracket, now I am getting invalid operation? Thoughts

Genevieve P.

Hey @Buster Davis

Can you double check that both of your columns are set as Date Type? We can see that the Go Live Date is a Date column, so can you check that the "Actual End" column is set as Date?

I would also suggest checking to see if the Actual End is not blank versus not being 0, since a Date won't ever be 0.

=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> ""), "On-Time", "Exceeded")

Buster Davis

Thank you your formula worked perfectly..