osipmikhail

Sorry just saw Jim’s response.

In that case is there anything I can do?

Not sure if this helps but you can see just from the import process it already has set the date to US format before even setting where the data should go to.

https://conservativeactive.com/testing/wp-content/uploads/2017/12/date.png

Hi,

Thanks for coming back to me, appreciate considering its the holiday season.

I did the above and even though it does exactly what it was supposed to do the date is still in American format.

It was my fault not to state precisely what I was importing to, I am using the Pods plugin, the date format I have set is to dd/mm/yyyy although I’m not exactly sure if not using pre-determined format makes a difference.

Sure, each record has the title set to take in the division name, the date and division number.

The excel screenshot shows what data I’m importing, the WordPress screenshot shows what happens after the data is imported. The date is in American format, the trouble is the url’s will be based in what shows in the title of the record. It won’t match because the date format is different.

https://conservativeactive.com/testing/wp-content/uploads/2017/12/data.png
https://conservativeactive.com/testing/wp-content/uploads/2017/12/data1.png