Date Format

[upaliwije]

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

[its_anandrjs]

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

];

[SergeyMak · Accepted solution]

Date(YourDateField,'DD-MMM-YYYY')

[upaliwije]

Thanks a lot

[its_anandrjs]

Did you check my reply.