topic Re: Date Format in QlikView

Date Format

upaliwije — Thu, 12 Jun 2014 05:02:29 GMT

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

Re: Date Format

its_anandrjs — Thu, 12 Jun 2014 05:17:09 GMT

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

];

Re: Date Format

SergeyMak — Thu, 12 Jun 2014 05:23:31 GMT

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

Re: Date Format

upaliwije — Thu, 12 Jun 2014 05:27:19 GMT

Thanks a lot

Re: Date Format

its_anandrjs — Thu, 12 Jun 2014 05:29:13 GMT

Did you check my reply.