Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Split (with string functions MID) into DD MM YYYY thes use Makedate function
Can you give me an example please ? I'm assuming this is in the LOAD statement ?
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
MakeDate(Mid(myDate,1,4), Mid(myDate,5,2), Mid(myDate,7,2))
let me know
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.
The date field doesn't appear in the list in the left as it's a dimension, not an expression.
oky, In your dimension tab, say Date is your field:
try this:
date(YourDate,'DD/MMM/YYYY')
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
try
date(date#(Yourdate,'YYYYMMDD'),'DD/MM/YYYY')
hth
Sasi