I need to enter a date into a date field on an application. In the excel file the date format is saved as, “dd/MM/yyyy”, however, when it is entered into the application it is entered in the format, MM/dd/yyyy.
Note: the date format of the application changes based on the system’s date format.
Is there a way to format the date from the excel file to the same format as the system’s date?
I have tried formatting the date using the code: