Mismatch of Field types for Date on pm_project and resource_plan tables

[praveenasurap]

Hello All

We are creating a report in Platform Analytics in Yokohama and trying to compare two dates below. The type on this field is different and hence causing incorrect data matches. Is there a way to get around this issue? Please note: These Field Types are out of box and the fields are out of box from ServiceNow. 

Table: pm_project

Field: Planned End Date

Field Type: datetime

Table: resource_plan

Field: End Date

Field Type: date