Dates importing in US format
If you are importing dates to the ClickSend dashboard and they are converting to a US format you will need to update the formatting in your Excel file.
- Open your file in Microsoft Excel
- Right-click the column containing dates
- Select "Format cells"
- Click "Date" under Number >> Category
- Ensure the Location (Language) is set to be United Kingdom (English)
- Select formatting that shows the date in the dd/mm/yyyy format