Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to format date in straight table. I want all the date fields in mm/dd format, ie (01/20).
Earlier I had used the following script .. Date (field name, 'MM/DD') but this has to be individually applied to each dimension field, I have 10 date fields in my table and dont want to individually apply to all. How can I do it globally?
Hi,
In Script
SET DateFormat='MM/DD';
and then use Date(DateFieldName)
Regards
did you try the date format definition in the number tab of the chart properties?
regard
Marco
Hi, if you want this MM/DD format for all your dates
you can modify the variables that automatic create at the top of the script, see this
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='$U #.##0,00;($U #.##0,00)';
SET TimeFormat='hh:mm:ss TT';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';
good luck
Fernando
Hi Rohan,
In Script Main Page If you Set Date Format='MM/DD' then you can use globally.
hope this helps
regards
Marco