My VBA is of average standard but not great.
I inherited some code which is beyond my understanding.
In simple terms the code uploads data (esp a date field) from a CSV file in tblBankAIB
The format of the date I need is dd/mm/yyyy - However, the upload seems to mix dd/mm/yyyy and mm/dd/yyyy.
I believe that the code in mdlStatementsUpload is the relevant bit.
How do I adjust this code to ensure that the date format dd/mm/yyyy is what loads into tblBankAIB
This 53 second video shows the load process and error.
Thanks for help!