How create a comparision report based on project task table using planned end date

[cn505666]

Shared a screenshot. I want to create a report where I want to bring all the data that do not match between 

(Timekeeping Task) Planned end date

(Project) Planned end date

Meaning gives output of all mismatch end date

Table: Project Task [pm_project_task]

Column to compare: Planned end date with Top project.Planned end date

[Mark Manders]

I assume this is a type of task that runs on the same start/end date as the project (or is supposed to)? Because otherwise, you will get a lot of tasks that are simple ending somewhere during the project.

Are you using the project workspace, where this can be seen in a quick overview?

For a separate report: to enable seeing all the field, you will have to create the report from the project task table (if you do it from the project table with related list conditions, you won't be able to access the fields from the task). You can use a query like below (or any variation you need)

And you can select all the fields from your task AND (top)project to show in your list report.

[cn505666]

I tried using that filter condition, but not giving me the output that the user is able to get in excel, i.e. filter only the false ones that do not match

[Mark Manders]

You are getting a list with all project tasks that have a different end date than the project. That was your requirement, right? How is this condition not giving you that?