Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Date Format

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?

5 Replies

Re: Date Format

Hi,

In Script

SET DateFormat='MM/DD';

and then use Date(DateFieldName)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Date Format

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

regard

Marco

Partner
Partner

Re: Date Format

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

qlikviewnovice
Valued Contributor II

Re: Date Format

Hi Rohan,

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

Re: Date Format

QlikCommunity_Thread_166140_Pic1.JPG

QlikCommunity_Thread_166140_Pic2.JPG

QlikCommunity_Thread_166140_Pic3.JPG

QlikCommunity_Thread_166140_Pic4.JPG

hope this helps

regards

Marco