Hi,
Hoping some one can help with the above.
I am trying to create a timeline on a pivot table where I have a lot of call data, exported from CMS (Avaya CMS Supervisor) into a table in excel.
The date column has been formatted to Date and 14/03/2012 but I still get the above error. Within the pivot table if you select the date column in row's it displays all the dates in the correct format.
I also get the same error when I do an export from a workforce management tool called Teleopti.
Has anyone got any ideas how make the time line pick up the date format?
Many thanks
Jonathan
Hoping some one can help with the above.
I am trying to create a timeline on a pivot table where I have a lot of call data, exported from CMS (Avaya CMS Supervisor) into a table in excel.
The date column has been formatted to Date and 14/03/2012 but I still get the above error. Within the pivot table if you select the date column in row's it displays all the dates in the correct format.
I also get the same error when I do an export from a workforce management tool called Teleopti.
Has anyone got any ideas how make the time line pick up the date format?
Many thanks
Jonathan