Date Picker is not recognising Date Field

[leobhavin]

Hi,

I installed the latest version of Qlik Sense desktop, and I am trying to use the date picker tool. However, it is not recognising a field value for date.

I have attached the script to this post.

My date is in the format DD/MM/YYYY hh:mm:ss and is currently showing as a "Timestamp" field within Data Manager.

I don't know what is wrong as I see the "floor" usage in the script already. Please help.

[Vegar]

It could be that it is not recognizes as a date. Try to put a dayname() or date() around it in the script to format it as a date.

[Channa]

try to use date format same as your default SET variable format

[leobhavin]

Hi Channa

I tried to use the default SET variable format i.e. Date = DD/MM/YYYY and also tried TimeStamp = DD/MM/YYY hh:mm:ss[.fff] but both didn't work

[leobhavin]

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.

[bbergstrom]

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?

[Shisho_Karsenty]

Hi,

You must be sure that your field is of a date type.
You can easily check this with the following expression:

If( Len(Num(SubTask_FromTo))=5 , 'Date', 'String')

(Thanks @b_garside  - link)

In my case the field was formatted as a string
And I had to convert it to a date format in the script:

Date#(Date (FieldName, 'DD/MM/YYYY'), 'DD/MM/YYYY') as FieldName_DateFormated

[Alvaro_Palacios]

Hi,

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.

I hope this helps.