Date Range Picker does not recognize date field

[mikegrattan]

The new Date Range Picker in Qlik Sense Enterprise November 2018 is not recognizing one of my fields as a valid date field.  The field is created during the data load as:

Date(ReceivedTime)

The format of the field prior to Date conversion is DateTimeStamp.  The field looks right in a table, and I can select dates manually from a filter panel or from the filter on the column in a table, but it is not listed as a date field in the date range picker.  I tried using the custom configuration and manually edited the date range picker to use my field, but it doesn't allow a range of dates to be selected.  It will work when choosing Last 30 Days, but not an actual date range, the dates are not able to be selected and are grayed out.

[m_woolf · Accepted solution]

Try changing the load script to:

Date(floor(ReceivedTime))

[mikegrattan]

That worked.  Thanks!

[piotrekc]

Hi,

In my case I have null values in field and Qlik doesn't regonise this as 'data' type and doesn't show it in range picker.

I solve this by add this line:

TAG field [date field] with '$date';

[imrasyed]

Awesome.

Thanks for your answer here.It saved my lot of time for which i was scratching my head.

[tasheer10]

Where should I add that line?

[imrasyed]

You can add it anywhere but make sure he field or table  has to be Loaded.

[sri94aa]

Actually this answer made my day!