This content has been marked as final. Show 2 replies
I'm running into a peculiar situation, whereby my dates aren't being seen as date. When I run the below script.
BreadCrumbs: LOAD breadCrumb_Id, breadCrumbDateTime, YEAR(breadCrumbDateTime) FROM [lib://\RestrictedDataSet.qvd] (qvd);
on the attached QVD, I get that the year is blank.
The only thing that I can think of is that the source for my QVD is a MySQL Community server, and Qlik doesn't know how to get metadata that says "this field is a date field" from the connection.
Any help on why this date isn't being seen as a date would be greatly appreciated.