
Not applicable
2017-06-01
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- date fromatting
2,098 Views
1 Reply

Anonymous
Not applicable
2017-06-01
12:21 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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')
1,996 Views
