Hi,

I'm unable to reproduce this.

I created a text file with the following values:

45-2010
03-2011
29-2008
01-2011

I then imported this into DataManager. DataManager read the data as TEXT. I then used a field organiser to convert the data to Date/Time, using ww-yyyy as the input Date format and dd-MMM-yyyy as the output date format. Omniscope correctly provided the following data:

08-Nov-2010
17-Jan-2011
14-Jul-2008
03-Jan-2011

So it did recognise the first week in 2011. Would it be possible to attach an example IOK/CSV file so we can investigate this further?

Thanks

Chris

Here you go. Cell content is not recognised for example in row #1978 or in #1984.

Hi,

For some reason the Hungarian locale and the time-zone are affecting this. Try changing the locale to 'English' or 'French' and the time-zone to GMT+0.00. This allowed me to parse the data correctly.

Hi Chris,

Thanks for your answer but I still have some problem with date formatting when I want to convert days into weeks.

After setting the proper date formatting in Omniscope, all the days from 20 Dec 2010 to 26 Dec 2010 will be 52th week in 2010 while it should be 51th, according to my calendar and other calendars what I found over the Internet.

My another problem is that Omniscope convert the days from 27 Dec 2010 to 31 Dec 2010 to the 1st week of 2010 which is obviously nonsense.

I've tried to change local settings to UK English and French but still got the same problem.

Thanks,
Miklos