Convert do date

[#1]

I have a table by name COSB_AGM

there are many fileds in this table which are like wkgoo1

so i want to convert this in dat formate

iam trying this way but its not working

wkgoo1 as 01-12-2014 its giving error in the script  and i tried like this also

wkg001 as 01/12/2014 but to its not taking ,

what do i need to do to achieve this ?

regards

here is the script  i want to achieve in date

COSB_AGM:

LOAD

[Object number_OBJNR],

[Value/Obj. Crcy_WOG001] as 01,04,2014 ,

     [Value/Obj. Crcy_WOG002]  as 01,05,2014 ,

     [Value/Obj. Crcy_WOG003] as  01,06,2014 ,

     [Value/Obj. Crcy_WOG004]  as 01,07,2014,

     [Value/Obj. Crcy_WOG005]as 01,08,2014 ,

     [Value/Obj. Crcy_WOG006] as 01,09,2014,

     [Value/Obj. Crcy_WOG007]as 01,10,2014 ,

     [Value/Obj. Crcy_WOG008] as 01,11,2014,

     [Value/Obj. Crcy_WOG009] as 01,12,2014,

     [Value/Obj. Crcy_WOG010] as 01,01,2014,

     [Value/Obj. Crcy_WOG011] as 01,02,2014,

     ([Value/Obj. Crcy_WOG012]+

     [Value/Obj. Crcy_WOG013]+

     [Value/Obj. Crcy_WOG014]+

     [Value/Obj. Crcy_WOG015]+

     [Value/Obj. Crcy_WOG016]) as 01,03,2014

     Resident COSB;

   STORE COSB_AGM into COSB_AGM.qvd ;

[jagan]

Hi,

Try like this

Temp:

CrossTable(Week, Value)

LOAD

*

FROM Cosb_Resident.qvd;

Data:

LOAD

*,

Month(Date) AS Month;

LOAD

*,

Date(Date#(Week, 'DD-MM-YYYY')) AS Date

RESIDENT Temp;

DROP TABLE Temp;

Hope this helps you.

Regards,

Jagan.