Do you know why QlikSense doesn't recognize my column as a date field while the other does?

[Waïl_Riachi_Sanofi]

Do you know why QlikSense doesn't recognize my column as a date field while the other does? yet they are the same format... there is no small date logo which shows that the field is

[JuanGerardo]

Allo @Waïl_Riachi_Sanofi, the automatic format recognizer in Qlik Sense may depend on different factors, and although it success in many cases there could be some of them that not. For this cases, you can force Qlik Sense to treat that field as date using tags in the script. For example:

Tag field MyDateField With $date;

JG

[Waïl_Riachi_Sanofi]

@JuanGerardo Hello, where I put this tag ? In the Data Load Editor here ? Below the last line ?

[JuanGerardo]

I recommend to put this line just after this field is loaded, or in a section at the end of the script dedicated to tags.

JG

[Waïl_Riachi_Sanofi]

I didn't understand, where exactly should I put it? Cause I never touched the script

[JuanGerardo]

I suggest to open the script editor, add a tab at the end, and add that line there.

But if you are using the Data Manager (the wizard), you can try first to tell Qlik Sense to read that field as Date:

JG

[Waïl_Riachi_Sanofi]

I tried to do as you said (the wizard) and load but it still doesn't recognize me as a date. I still don't have the little calendar logo next to my variable

[JuanGerardo]

It's difficult to imagine the cause then. Could you attach some sample data?

JG

[Waïl_Riachi_Sanofi]

My app is connected to a database so I have no Excel sample to share and I have shared all possible screenshots in the post as attachments

the problem is that NULL values ​​are automatically transformed into 01/01/0001 based on which I am logged in. And Qlik doesn't seem to like this Date format so I would have to manage to transform these dates how do I do?

[JuanGerardo]

Hi, maybe your problem is then to manage nulls. You can have a look at this page: https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/null-value...

JG