Date field not showing for Date Picker

[MaxRd]

Hi

In one of the tables in my data model I have a date field and it is not showing up when I try to create a date picker.

The field is used to create an association with another table, so I wonder if that is the reason why it does not show as a field available?

I'm not using the load editor or anything like that, I have simply dragged and dropped my data into the data manager and then manually created the associations.

Thank you in advance for any help.

[marcus_sommer]

Your date is probably not a date else a timestamp. This might be changed with something like:

date(floor(MyField)) as MyField

[MaxRd]

Hi Marcus

Thank you for your advice.

The date field seems to be formatted correctly 

With regards to the method you suggested, would that formula just be used in a new field? Or is that something to be done in the data load editor? I have never used the data load editor so I'm not too sure how to do that.

[marcus_sommer]

I never worked with the data-manager but AFAIK there are also (limited) possibilities to apply transformations. Within the load-editor it's very simple and would mean to add respectively adjust something like above shown.

But if I look on the various meta-data it seems to be really a date because 912 distinct and total values are fitting for date-range. So I'm not sure why the date-picker didn't accept it. What happens if you tries another date-field like the Stock-Date? 

[rwunderlich · Accepted solution]

The Date Picker will only offer fields that have a "$date" tag.  Your OrderDate likely does not have this tag. You can see the tags associated with a field in the Data Model Viewer preview window. 

You can get the $date tag assigned to the field in one of two ways. 

1. In Data Manager, edit the table and change the datatype in the dropdown to Date. 

2. At the end of your load script add a TAG statement. 

Tag Field OrderDate with '$date';

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com