Date format issue: Month lenght = 3 characters

[philav]

Hello All,

I would like to fully automate the import of my operation file but the month is not properly identified.

The date formate is as follow : 01 Mar 2012
My current workaround is to open the files in Excel, change the format of the column to dd/MM/yy and save it in CSV again.

I would like to know if there a away to describe the format in order to help the application to detect the format automatically.

Thanks and Regards

Philippe

[Angeman]

You can use dd MMM yyyy.

[philav]

Hello Angeman,

Thank you for your feedback.

I re-tried but unfortunately it did not work.
My keyboard and language is US. My version is 4.0.11.

Let me know if there is any information I can provide you to help.

Thanks
Philippe

[Angeman]

Are you international setting like this ?

Capture d’écran 2012-04-16 à 10.15.24 AM.png (53.33 KiB) Viewed 6643 times

With these international settings I just tried with dd MMM yyyy and it worked fine.

Capture d’écran 2012-04-16 à 10.15.51.png (35.8 KiB) Viewed 6643 times

[philav]

Hello Angeman,

First of all: it's works.

The issue was the region. I am french and but my keyboard is US ( I live in Asia), so the region was " Personnalise"
So I change it to my country (Singapore) and then I was able to import it straight a way.

Thanks for you time and the pictures

Regards

Philippe