change 01 AUG 2012 to 01/08/2012 format

[Anonymous]

Hi

There is a medium date field eg.01 AUG 2012 which i want it in this 01/08/2012 format.

Thanks!

[sujeetsingh]

Try to use Date() and Date#() functions ...It will help you.

[#3]

This seems to work

= DATE(DATE#(Mydate,'DD MMM YYYY'), 'DD/MM/YYYY')

Cheers

[nirav_bhimani]

Hi,

Try This,

Num(Month(Date_Field))

Or Else

if(Month='Jan',1,if(Month='Feb',2,if(Month='Mar,3.........))))))))))))

Regards,

Nirav Bhimani

[Sokkorn · Accepted solution]

Hi adoteykwame,

Let consider this expression: Date(Date#('01 AUG 2012','DD MMM YYYY'),'dd/MM/yyyy') return 01/08/2012

So you can try

     1. Expression: Date(Date#(YourDateField,'DD MMM YYYY'),'dd/MM/yyyy')

     2. Load script: Date(Date#(YourDateField,'DD MMM YYYY'),'dd/MM/yyyy') AS [Dates]

Hope this help

Regards,

Sokkorn

[martin59]

Hi,

You have to use this expression in your LOAD script :

Data:

LOAD Field1,

     Field2,

     ...,

     Date(Date#(YourDateFied,'DD MMM YYYY'),'DD/MM/YYYY') as Date

FROM Data.qvd (qvd);

Hope that helps you,

Martin Favier

[Anonymous]

Thanks alot guys especially Sokkorn Cheav and Martin Grape.

[#8]

Hi,

Try This

Month:

MAPPING LOAD * INLINE [

    Month, num

    AUG, 08

];

tab1:

LOAD * INLINE [

    F1

    01 AUG 2012

];

tab2:

LOAD F1,

           Date(Makedate(SubField(F1,' ',3),applymap('Month',SubField(F1,' ',2)),SubField(F1,' ',1)),'DD-MM-YYYY') AS Date

RESIDENT tab1;

DROP table tab1;

Regards,

Vivek