Account Table: This table contains information about the accounts held by the bank's clients. It includes the
account_id district_id frequency Date - the date the account was opened Account_type
ACCOUNT Table
Changes Made With Excel
| Column | Description | Changes | Missing or Invalid Values | Notes |
|---|---|---|---|---|
| Account_id | Identification of the account | None | N/A | Primary Key |
| District_ID | Identification of the branch | None | N/A | Foreign Key |
| Frequency | Frequency of Statement Issuance | Translated values as follows:- POPLATEK MESICNE changed to MONTHLY ISSUANCE (MI) |
Step 1 Convert the text date into the date
Use this function in excel to chance date
“=DATE(LEFT(D2,2)+24, MID(D2,3,2), RIGHT(D2,2))”
Certainly, let's break down the formula =DATE(LEFT(D2,2)+24, MID(D2,3,2), RIGHT(D2,2)) step by step: