How to write a query to get accurate "when is the employee start date?" from the Offer

Summary:

Hi Team,

We are trying to add value for "When is the employee start date?" in one of ours Offer accepted report. However when the employee start date is changing the report is not picking up correct date.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Select nvl(to_char(paam1.effective_start_date,'DD/MM/YYYY') ,to_char(paam1.projected_start_date,'DD/MM/YYYY'))
From per_all_assignments_f paam1
--Assignment linked to Pending Worker record