I’m trying to create a calculated column which calculates the difference between two dates in two date columns (beginning and end of a task assigned to a user). The hang up is that, if the date in one of the columns reads “1/1/1900 12:00:00 AM”, I want the result to be a blank value. The system automatically displays this date when the task isn’t complete.
Here’s what I have so far (which is producing an error)
Days to Complete Task = IF(DQ_VW_Tasks[closed_at] = “1/1/1900 12:00:00 AM”, Blank(), DATEDIFF(DQ_VW_Tasks[sys_opened_on], DQ_VW_Tasks[closed_at], DAY) )
Here’s a screenshot of the column with the date I’m trying to filter out of the results.
I believe the issue is that my if statement is trying to capture a text value, when I need to capture a date value. However, I don’t know how to format the date value in the if statement. I think it’s an easy fix.
Thank you!
@Harsh Any ideas on this one?