Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Date format to MMDDYY?

I am using Qlik Sense and using Table. I have a date field that is mm/dd/yyyy (06/01/2017) but want it to be mmddyy (060117). is that even possible, of so how?  Even when I import an excel spreadsheet with mmddyy; Qlik Sense coverts it back.  I am new and trying to understand what Qlik can(not) do.

Tags (1)
1 Reply

Re: Date format to MMDDYY?

I reckon it could well because your default QlikSense date format is 'MM/DD/YY'.

Try forcing the field to your required format with something like :

     Date( [YourDateField] , 'MMDDYY')