Client id | Client Name | Project Info | Status |
1 | ROHIT GUPTA | START DATE | 2020-04-13 |
1 | ROHIT GUPTA | DATE FINISHED | 2020-04-26 |
@rohit782192 can you please share your expected result?
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!