Entering Dates online and in excel offline

If you use the drop down calendar then the date will be formatted correctly. For manual entries where you actually type in the date, just make sure you type 3 letters for the month before it will accept any dates. Make sure you actually type in dates directly into the date field if the year is many years back. This will be quicker than using the drop down calendar. What about Excel Dates for upload? eg batch import of new employees from Excel. Check that the date is not reverted by your Excel to the American Standard. It is determined by your Excel Standard-Date-Format options. Eg 22/02/2019 is 22 of February 2019 or 22/Feb/2019 Check your excel does not switch to the America Standard which would make this same date you enter change to 2/22/2019. If you highlight the Excel-Cel with the date in question and then look at the Reference in the Formula Bar it will show you what excel format you are using. Or you can check your Excel Standard-Date-Format by clicking on format cells and then checking the Date is for example English(UK). It should not be a Date Format that has the Month before the Day. (like the American version) For any import or update process that involves dates, please make sure that your computer system settings on windows are correct before you even open excel and do the download or the upload for Harvester online files. How do I set my region date format to English UK or Zambia? Go into Control Panel then Clock then Language then and Region. In the Formats tab, check that the: Format is set to English (United Kingdom). Short date format in Date and time formats is set to dd/MM/yyyy. The Zambia default also works on dd/MMM/yyyy.