How we do a date difference of the project info Start Date and Date Finished against name

[rohit782192]

Client id	Client Name	Project Info	Status
1	ROHIT GUPTA	START DATE	2020-04-13
1	ROHIT GUPTA	DATE FINISHED	2020-04-26

[binuacs]

@rohit782192 can you please share your expected result?

[DawnDuong]

hi @rohit782192 

There are many ways to do this. One possible solution is:

- First restructure your data with a CrossTab tool to bring out the start and end dates as separate fields, with client ID as key fields. I have created a fake Mohit Gupta 2 pair of rows just to illustrate the concept.

- Then use the formula tool to calculate the date difference.

Dawn.

P/S: Are you ex-GTS Mohit Gupta that I know? If so, hello old friend, long time no see!

[grazitti_sapna]

hi @rohit782192 you can use multi row field. attached is the solution.

[rohit782192]

share your workflow