4 Replies Latest reply: Mar 29, 2013 9:33 AM by Loïc Orue RSS

    Extract date from a week?

      Hello,

       

      I'm currently working on data where the date is set as week 1 week 2 week 3 (week 1 begining January first). Id like to know if there is a way to transform this data into dates when I load my table?

       

      This is what my loading script looks like atm:

       

           CrossTable(Weeks, Load, 4)

           LOAD [People]    as [Collab],

                [Center],

                [Projet],

                [Activity],

                Week1,

                Week2,

                Week3,

                Week4,

                Week5

                ......

       

      Thanks in advance for any help concerning this matter!