Forum Discussion
Compare dates and calculate %
Hi, I need to compare two dates (completion date & target date) and calculate a % of items that were completed within the set target date. My data looks like below : Item # Completion date ...
Anonymous , check data type of both columns it should be date and datetime
Also this should be column
SLA = If(TestWorkFlow[ActualCompletionDate]< TestWorkFlow[TargetDate],"Met", "Not met")
Also check for date form dd/mm/yyyy
amitchandak
Super User
Super UserAnonymous , check data type of both columns it should be date and datetime
Also this should be column
SLA = If(TestWorkFlow[ActualCompletionDate]< TestWorkFlow[TargetDate],"Met", "Not met")
Also check for date form dd/mm/yyyy
amitchandak Thanks. It worked. I didn't check the field/data type for one of the dates that's what was causing the error.