Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
leobhavin
Contributor II
Contributor II

Date Picker is not recognising Date Field

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.

 

 

Labels (2)
7 Replies
Vegar
MVP
MVP

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
Specialist III
Specialist III

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

Channa
leobhavin
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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
Partner
Partner

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
Contributor III
Contributor III

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
Support
Support

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.