Solved: Date Format - Qlik Community

Report Inappropriate Content · ‎2015-05-30

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

siddheshmane · ‎2015-05-30

Hi,

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

View solution in original post

siddheshmane · ‎2015-05-30

Hi,

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

Report Inappropriate Content · ‎2015-05-30

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

marcus_sommer · ‎2015-05-30

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

The Master Calendar

- Marcus

Report Inappropriate Content · ‎2015-05-30

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

PrashantSangle · ‎2015-05-30

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Date Format

Related Topics