Hi All,
Need help to compute date difference if there's value on the Match field. Need to get the # of days difference on the transaction date column. Source should always be between Grab and AMEX with same amount.
Transaction Date | Source | Amount | Match | # f days difference |
1/23/2019 | GRAB | 102 | 2019-01-23,102.00,AMEX | 0 |
1/23/2019 | AMEX | 102 | ||
1/23/2019 | GRAB | 103 | 2019-01-23,103.00,AMEX | 0 |
1/23/2019 | AMEX | 103 | ||
1/29/2019 | GRAB | 104 | ||
1/21/2019 | GRAB | 105 | 2019-01-21,105.00,AMEX | 0 |
1/21/2019 | AMEX | 105 | ||
1/24/2019 | GRAB | 105 | 2019-01-24,105.00,AMEX | 0 |
1/24/2019 | AMEX | 105 | ||
1/24/2019 | GRAB | 106 | 2019-01-24,106.00,AMEX | 0 |
1/24/2019 | AMEX | 106 | ||
1/22/2019 | GRAB | 107 | 2019-01-22,107.00,AMEX | 0 |
1/22/2019 | AMEX | 107 | ||
1/22/2019 | GRAB | 107 | 2019-01-22,107.00,AMEX | 0 |
Thanks,
Rob
Solved! Go to Solution.