Issue with date format when uploading data onto Eloqua
For the last couple weeks when uploading data onto Eloqua (both contact lists and Custom Objects), the system is changing the date format, therefore rejecting quite a few of the fields.
Here is whats happening, on the excel sheet the date is set to dd/mm/yyyy. On Eloqua within the display setting, I have made sure that the same is selected.
When I actually upload the data though, Eloqua switches the dd and the mm, therefore rejects any field where the dd is above '12'.
Has anyone else had this issue?
On another note, we have been doing the same upload every week for the last 10 weeks and have only had this problem for the last two weeks. The formatting of the export (or what we are uploading) hasnt changed.