Cape Machinery sells various types of machinery and equipment. You have been provided with the attached sales data records. You noted different date formats are used in the document. The records are for the February to May 2023 period. From the knowledge you have acquired from the Computer Advanced module, create a sales report for the company's management by answering the following questions. Required: 1.1 Correct the date format in the sales record to use the YYYYMMDD date format (4 marks) 1.2 Calculate the total sales recorded for each item and the total sales for the period. (3 marks)