I converted it to a Date in SQL Server:
In my SQL:
CONVERT(Date, DateFieldNameHere) as ThisDate
In the LOAD statement, am referencing ThisDate
It pulls the data into Qlik Sense correctly, just doesn't recognize it in the Date & Time bucket.
I am also able to correctly run Qlik functions like Year(ThisDate) against the data.
they won't show up by default under Date & Time fields. You would need to add some script in the data load editor to ensure that happens. The subject area is called 'derived fields'
There are no limitations to NOT using derived fields apart from the nice organization on the left side. There are a few more limitations to date & time fields (derived fields) that can make it work just keeping the field as is . For example, derived fields have not been yet supported in set analysis .
does this help ?