Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Date Format

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

8 Replies
jerem1234
Specialist II
Specialist II

try:

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

Hope this helps!

MK_QSL
MVP
MVP

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

or

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

Here YourDateField=sent_date

upaliwije
Creator II
Creator II
Author

Thanks

Pls tell me where should I enter this format

MK_QSL
MVP
MVP

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

upaliwije
Creator II
Creator II
Author

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

MK_QSL
MVP
MVP

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

MK_QSL
MVP
MVP

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

upaliwije
Creator II
Creator II
Author

Thanks

It is working