How do I format a date in a pivot table ?

[#1]

Hi All,

I have a sheet object (a pivot table) which displays a date as YYYYMMDD. How can I format it to display as DD/MM/YYYY ?

Thanks

MV

[alexandros17]

Split (with string functions MID) into DD MM YYYY thes use Makedate function

[#3]

Can you give me an example please ? I'm assuming this is in the LOAD statement ?

[marcus_sommer]

I suggest to do this (maybe as an additionally field) within the script maybe in a master-calendar instead in (many?) gui-objects, see also: How to use - Master-Calendar and Date-Values.

- Marcus

[alexandros17]

MakeDate(Mid(myDate,1,4), Mid(myDate,5,2), Mid(myDate,7,2))

let me know

[Anonymous]

Two ways:

1) In the script at main tab:

Set DateFormat='DD/MMM/YYYY';

2) Right Click on Pivot table and go to number tab, select the field from left list and override the date format.

[#7]

The date field doesn't appear in the list in the left as it's a dimension, not an expression.

[Anonymous]

oky, In your dimension tab, say Date is your field:

try this:

date(YourDate,'DD/MMM/YYYY')

[Colin-Albert]

Has the data been loaded as a date field?

Have a look at this post which shows how to load dates correctly.     Get the Dates Right

[sasiparupudi1]

try

date(date#(Yourdate,'YYYYMMDD'),'DD/MM/YYYY')

hth

Sasi