importing date and time

[dena ponech]

Hello all,

I am just trying out FlexPro 6 demo version and practiceing importing files. My x column contains a date and time, but it is in a different format than expected by the import wizzard. the string in the data looks like
‘ 22-Jun-2006 21:10:05 ‘
Is there a way to change the string format of the import wizzard??

Thanks

[dena ponech]

Hello all,

I am just trying out FlexPro 6 demo version and practiceing importing files. My x column contains a date and time, but it is in a different format than expected by the import wizzard. the string in the data looks like
‘ 22-Jun-2006 21:10:05 ‘
Is there a way to change the string format of the import wizzard??

Thanks

[Bernhard Kantz]

After the import you have the possibility to change the calendar time format.

Select the dataset and open the [b]Properties Window[/b] in the Context Menu.
Choose the tab [b]Formatting[/b].
Click the [b]Change…[/b] button and choose the tab [b]Calendar Time Value.[/b]

In this dialog you can choose your Calendar Time format.

support@weisang.com

[dena ponech]

Thanks for the reply,

I have tried that, but it is not working, just get ?’s in the column.

When I import, I am choosing D M Y h m s for the format, should I choose something else? I only get ?’s in my x column when I do this.

Thanks
Dena

[Bernhard Kantz]

the Ascii Import filter cannot import your data correctly (because of the language specific month format).
But there is a workaraound:
– Import the the column with the time values as strings. In this case you have to import the column as y-values.
– After the import you can convert the dataset with the strings to the data type Calendar time. (Context Menu|Properties|Data Types)

But this conversion is dependent on the OS local settings. For example the conversion of ‘Mar’ only works with an English OS.

support@weisang.com

[Author]

Posts