Date Format

[#1]

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?

[PrashantSangle]

Hi,

In Script

SET DateFormat='MM/DD';

and then use Date(DateFieldName)

Regards

[MarcoWedel]

‌did you try the date format definition in the number tab of the chart properties?

regard

Marco

[fkeuroglian]

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

[Anonymous]

Hi Rohan,

In Script Main Page If you Set Date Format='MM/DD' then you can use globally.

[MarcoWedel]

hope this helps

regards

Marco