2 Replies Latest reply: Aug 28, 2012 3:53 AM by giobenoni RSS

    sticky date format

      Hi, I have an xls with monthly price updates which i want add to my existing reports.

       

      Problem is that this file has a manual month name instead of a real date format :

       

      format is

       

      'Jan 12

      'Feb 12

      'Mar 12

       

      is there any way to fix this and convert it during load? I'd like to use it with my standard date island.

       

      thanks for any input!