Date Format

[upaliwije]

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

[jerem1234]

try:

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

Hope this helps!

[MK_QSL]

=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]

Thanks

Pls tell me where should I enter this format

[MK_QSL]

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]

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]

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

[MK_QSL · Accepted solution]

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]

Thanks

It is working