Date format to MMDDYY?

[#1]

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.

[Anonymous]

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')