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

[Tool_Tip]

Dear Rob,

Just want to confirm is this update after feb22 ? previously we were not doing any Tag settings so just to confirm.

[rwunderlich]

The Tag statement has been around for quite some time. The need to assign a $date tag is not related to any particular release AKAIK, it's just that occasionally the "auto tagging" doesn't work for a field and if so you can force it with the TAG statement.  The auto tagging usually takes care of things. 

-Rob

[Tool_Tip]

That's new to know for me. Well Can I know if which scenarios the auto tagging doesn't work? 

[rwunderlich]

One scenario is when an invalid date appears in the field. For example, in this load the field will not be autotagged with $date.

Load * Inline [
Somedate
05/14/2025
0
];

-Rob

[Tool_Tip]

Noted. In our case we have below four date field as shown in table chart and we are not getting any of it in the date picker drop down by default so Can we say that date with timestamp also required tagging forcefully ?