Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

6 Replies
dineshm030
Creator III
Creator III

Hi Srikanth,

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

Regards

Dinesh

tresesco
MVP
MVP

Try like:

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

eromiyasimon
Creator II
Creator II

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
Specialist
Specialist

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

Chanty4u
MVP
MVP

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;

new.PNG

Anonymous
Not applicable
Author

Simply apply following formula:

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


Thanks,