Variability in Dates

[Kish1999]

Hello All,

I have a requirement where we have a few key dates in our table and we want to check if the date has been changed and if yes then by how many days/Months. Below is the sample dataset and result:

Project	TargetDate1	TargetDate2	TargetDate3	Phase	Project Modified date
A	02-01-2023	02-02-2023	03-03-2023	Certify	05-01-2023
A	10-01-2023	02-02-2023	03-03-2023	Certify	06-01-2023
A	10-01-2023	15-02-2023	03-03-2023	Certify	08-01-2023
Result
Project	Previous TragetDate1	New TragetDate1	Variance TragetDate1	Previous TargetDate2	New TargetDate2	Variance TargetDate2	Phase in which changed
A	02-01-2023	10-01-2023	8 Days	02-02-2023	15-02-2023	13 Days	Certify

[lbendlin]

ok. What have you tried and where are you stuck?