Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Srikanth,
date(date#('fieldname','MM-YYYY-DD'),'DD/MM/YYYY')
Regards
Dinesh
Try like:
Date(Date#(Keepchar(YourCol, '0123456789'),'MMYYYYDD'),'DD/MMM/YYYY')
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
date(date#(right(fieldname,10),'MM-YYYY-DD'),'DD/MMM/YYYY')
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;
Simply apply following formula:
date(date#('DateField','MM-YYYY-DD'),'DD/MM/YYYY')
Thanks,