I have 2 tables, one table holds product code, start date, APR and Term....given the time loan was originated, the second table is Federal Home Loan, (FHL)..which holds date and Term only. FHL rates are given to us by Federal bank and we would like to compare.
Loan Table Fields
Code, StartDate, APR,Term
NV 11/24/1994 7.14 36
FHL Table Fields
Date,1,2,3,4,5,6,12,18,24,36,48,and so on
11/18/1994 6.13 6.24 6.47 6.79 and so on
Is there a way where first we can convert the date field on both tables to look like "November1994" so we can link these tables based on date and see what APR was given us by FHL and we then to customers.