Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
1/3/2013 0:00 |
1/4/2013 0:00 |
1/15/2013 0:00 |
1/22/2013 0:00 |
1/24/2013 0:00 |
1/31/2013 0:00 |
Pls let me know how to convert above date format to appear as follows in my document
31-MAR-2013
01-APR-2013
Try with this
Date(Date#(Dates,'M/D/YYYY hh:mm'),'DD-MMM-YYYY') as NewDate;
Eg:-
LOAD Date#(Dates,'M/D/YYYY hh:mm') as Dates,
Date(Date#(Dates,'M/D/YYYY hh:mm'),'DD-MMM-YYYY') as NewDate;
LOAD * Inline
[
Dates
1/3/2013 0:00
1/4/2013 0:00
1/15/2013 0:00
1/22/2013 0:00
1/24/2013 0:00
1/31/2013 0:00
];
Date(YourDateField,'DD-MMM-YYYY')
Thanks a lot
Did you check my reply.