topic Re: Date Format in QlikView

Date Format

upaliwije — Tue, 18 Mar 2014 17:04:05 GMT

Hi Friends

I have have a pivot table where one of the dimension is sent_date. The format of the date is 03/06/2014 but I want to date appear

like 06-Mar-2014. Pls help me

Thanks

Re: Date Format

jerem1234 — Tue, 18 Mar 2014 17:06:38 GMT

try:

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

Hope this helps!

Re: Date Format

MK_QSL — Tue, 18 Mar 2014 17:09:23 GMT

=Date(Date#('03/06/2014','MM/DD/YYYY'),'DD-MMM-YYYY')

=Date(Date#(YourDateField,'MM/DD/YYYY'),'DD-MMM-YYYY')

Here YourDateField=sent_date

Re: Date Format

upaliwije — Tue, 18 Mar 2014 17:13:15 GMT

Thanks

Pls tell me where should I enter this format

Re: Date Format

MK_QSL — Tue, 18 Mar 2014 17:15:40 GMT

You can enter this in your script also in place of your sent_date

Date(Date#(sent_date,'MM/DD/YYYY'),'DD-MMM-YYYY') as sent_date

Re: Date Format

upaliwije — Tue, 18 Mar 2014 17:34:22 GMT

Hi Manish

It is not working. Is there a any other way other than write it in the script. If possible pls let me know

Re: Date Format

MK_QSL — Tue, 18 Mar 2014 17:39:35 GMT

Let me have your script sample. It should work...

Re: Date Format

MK_QSL — Tue, 18 Mar 2014 17:49:53 GMT

Check below script...

Load

sent_date as sent_date_original,

Date(Date#(sent_date,'MM/DD/YYYY'),'DD-MMM-YYYY') as sent_date_new

Inline

[

sent_date

03/25/2014

04/26/2014

01/27/2014

];

==========================

Now create two list boxes...

one for sent_date_original

2nd for sent_date_new

Re: Date Format

upaliwije — Wed, 19 Mar 2014 04:52:40 GMT

Thanks

It is working