forums.lyricapps.com

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

You can use dd MMM yyyy.

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

Are you international setting like this ? With these international settings I just tried with dd MMM yyyy and it worked fine.

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