We have a large customer DB with customer contract information containing data points such as contract term (in months), start date and end date of contract. I need to generate a Query that determines what the end date should be from the start date + term, then compares the existing end date and flags any inconsistencies. Below is a sample of the info.
This is my first post in a long time as I have not been practicing IT for over 5 years and am getting back into it so please let me know if I am doing it correct.
Date Status Company Notes to Rep Rep ID UoM Usage Fee Yr 1 Payout Date Paid CID Supplier Term Start End Rate Commodity Utility Acct Service Addy City State Zip Contact Business T Phone # Cust Email 07-Aug-20 Yes test Co 1 PAID 3223 x 97,749.00 0.007 $684.24 2020-08-21 26289 EH 12 01-Sep-20 30-Aug-21 $0.06 E OH 212121 4280 Shem TEST 1 OH 11111 CUSTOMER 1 Owner 330
17-Aug-20 No Test co 2 9/1 Rejected 3223 x
0
26457 EH 12 01-Sep-20 30-Aug-21 $0.06 E CEI 545441 30584 Century TEST 2 OH 22222 CUSTOMER 2 Owner 330 26-Aug-20 Yes Test co 3 PAID 3223 x 30,090.00 0.007 $212.63 2020-09-11 26620 EH 12 01-Oct-20 30-Sep-21 $0.06 E OE 445454 4131 W slvb TEST 3 OH 33333 CUSTOMER 3 Owner 330