I Have a Column Data as (10-2014-09). I need to Format as Date (dd/mmm/yyyy)?

[#1]

Column Data

week of 06-2004-18

weeek of 11-2009-24

week of 02-2004-19

weeek of 03-2009-25

week of 10-2004-20

weeek of 11-2009-26

I want to Extract Date from the above column as DD/MMM/YYYY fromat?

[dineshm030]

Hi Srikanth,

date(date#('fieldname','MM-YYYY-DD'),'DD/MM/YYYY')

Regards

Dinesh

[tresesco]

Try like:

Date(Date#(Keepchar(YourCol, '0123456789'),'MMYYYYDD'),'DD/MMM/YYYY')

[eromiyasimon]

Use the below expression

=date(06-2004-18,'DD/MMM/YYYY')

OR

=date(Date#('06-2004-18','MM-YYYY-DD'),'DD/MMM/YYYY')

both will work

[varshavig12]

date(date#(right(fieldname,10),'MM-YYYY-DD'),'DD/MMM/YYYY')

[Chanty4u]

try this

a:

LOAD * INLINE [

    Date1

    06-2004-18

    11-2009-24

    02-2004-19

    03-2009-25

    10-2004-20

    11-2009-26

    ];

Result:

LOAD *,

date(Date#(Date1,'MM-YYYY-DD'),'DD-MMM-YYYY') AS NEW

Resident a;

[Anonymous]

Simply apply following formula:

date(date#('DateField','MM-YYYY-DD'),'DD/MM/YYYY')

Thanks,