topic Re: Date Format in QlikView

Date Format

Sat, 30 May 2015 08:43:00 GMT

I want to format date in straight table. I want a field in mm/dd format, ie (01/20)

siddheshmane — Sat, 30 May 2015 08:47:01 GMT

Hi,

Try using date(FIELD_NAME, 'MM/DD').

Sat, 30 May 2015 08:47:17 GMT

Ok found it> Date (field name, 'MM/DD')

marcus_sommer — Sat, 30 May 2015 08:48:47 GMT

It's better to format a date-field within the (master calendar) script and use them within the gui:

date(DateField, 'MM/DD') as ShortDate

- Marcus

Sat, 30 May 2015 09:02:50 GMT

What if i want to apply the format to all the fields?

PrashantSangle — Sat, 30 May 2015 09:14:28 GMT

Hi,

either do it in script, or use calculated dimension date(fieldName) if it is dimension

If it is expression then you can Format in chart->property->Number->Select date

and enter format in Format Pattern.

Regards