Change Date format in Pivot Table

[Anonymous]

Hi,

How can i change the date format in the pivot table?

Now it shows dd,mm.yyyy.

How can i change it to dd.mm.yyyy?

[anbu1984]

In Script,

Date(Date#(Dato,'DD,MM.YYYY'),'DD.MM.YYYY') As Dato

[#3]

hi,

go to chart property->

Date(Date,'DD.MM.YYYY')

[#4]

In your Pivot Table, Call your date as an expression (eg. =Date)

Go to Properties->Number Tab->Select Date(Left side)->then select 'Date' in Number Format Settings->Specify the format you require.

[Anonymous]

Now the date/dato displays two places..  I also tried to remove the "Dato" dimension but then i cant move the "Dato" expression under "Måned"

[Anonymous]

It does not work..  now I get "//Error in calc..." in every date cell.

[#7]

hi ,

send a test file of qvw.

Regards

Vimlesh

[jagan]

Hi,

Try like this in script

Load

*,

Date(Date#(DateFieldName,'DD,MM.YYYY'),'DD.MM.YYYY')  AS Date_Format

FROM DataSource;

Now you can use this field as dimension in the chart.

Regards,

Jagan.

[#9]

hi ,

clear one more thing your date is data source should be in date format not in text.

if you will use num(date) function then your date should be in number format.

if it is not showing in number  then go to script and use makedate function to convert Text date format

prefer attached QVW file

Regards

Vimlesh

[timanshu · Accepted solution]

Hi Marius,

Just Put this in dimension with Date field for which you want to display different format.

Date(Dato,'DD.MM.YYYY')

It works , as I checked.

If it still doesn't work for you then kindly attach the qvw.