Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Not all timestamp dates recognized in Qlik Sense

I have an excel data set in which when I go to edit the data in the data manager, Qlik does recognize the column as a time stamp. But, unfortunately leaves some rows blank despite the fact that my data set does have data for it. How can I fix this? I tried formatting the date in excel, but can not change this field at all. Any suggestions how to make Qlik read all the dates?

How my timestamp is displayed: 03/18/2021 12:00 PM

Picture of how Qlik Sense is recognizing it.