Hi, am a beginner to excel VBA and having an issue with a form I created in VBA to calculate annual leave for my organisation
When I enter the dates in the form for start date, from date and to date, it changes the format from dd/mm/yyyy to mm/dd/yyyy in the database where the data is being recorded. I understand it has something to do with me using a string for the data input box instead of a date string. But my knowledge and expertise in VBA is limited, I used a tutorial to create this form and then customised it to my organisation, everything works apart from this. Any help will be much appreciated as it is a tool we need at work to make life much easier. I have attached the file.
Thank you
When I enter the dates in the form for start date, from date and to date, it changes the format from dd/mm/yyyy to mm/dd/yyyy in the database where the data is being recorded. I understand it has something to do with me using a string for the data input box instead of a date string. But my knowledge and expertise in VBA is limited, I used a tutorial to create this form and then customised it to my organisation, everything works apart from this. Any help will be much appreciated as it is a tool we need at work to make life much easier. I have attached the file.
Thank you