Hi All,
In the attached excel sheet, i like to idenitfy the max expiry date, associated commencement date and finally display the result in a pivot as below. I have attached the sample workflow to illustrate the desired result.
Desired Result:
Tenant Code | Tenancy_Commencement_Date | Original_Lease_Expiry_Date | Seventh_lease_commencement_date | Seventh_lease_expiry_date |
40401 | 2015-10-19 | 2016-10-18 | ||
52090 | 2015-08-24 | 2016-08-23 |
Thanks
Solved! Go to Solution.
Hey Jag,
This should help you, its basically what Chris explained plus joining the two dates using a token. You will know when you open that workflow.
It seems that this is not the data at source and I believe the approach can be improved from the source.
For now, try to use this workflow, should solve your purpose. It was a good workout. :)
Thanks Chris. Before i could attempt Rahul cracked it.
Jag