I have also disabled profiling option and loaded the file and then chose the field type as Date, yet the date picker does not recognise it as date.
If I want to enable profiling and ensure the column is picked up as DATE field, please could you suggest what I should do in Excel spreadsheet. Even if the column has date only, Qlik Sense recognises the column as Timestamp when profiling is enabled.
I'm running into a similar issue and the documentation for this object seems to be lacking clear instructions. I have two date fields in the data set but I can only see one of them in the date field selector. Both of them are formatted as 'D/M/YYYY' and the only difference is that the one I cannot see is coming from a dom table that is not linked to any other field in the data set. I'm trying to use this field as it appears the date picker only allows the user to select dates available in the data.
Also, I'm confused about how to use the interface. There are two boxes at the top that appear to represent the start and end dates but when I enter a date in one of the fields nothing appears to happen. Are there any plans to make this object more useful?
When loading date fields via Data Manager, these will be automatically recognised and tagged as date fields. If you explore the auto-generated load script you'll see the following expressions for each date field:
Date(Date#(DateFieldName, 'DD/MM/YYYY'), 'DD/MM/YYYY') as formattedDate
If date picker object doesn't display that field, then try this trick: select one of the available fields from the drop down, enable 'Advanced Setup' (i.e. 'ON') and use the expression editor to enter the desired field manually.