Firstly, I'm pulling data into QlikView with dates like 17-Feb, 4-Mar, 12-Apr etc with no Year.
Now I know the Year for those dates were 2015, how can I add years to those dates?
Secondly, all future data sheets are going to have the same date format, is there a way that I can import the data and years gets assigned automatically? What are my options? I'd like to make it as dynamic as possible.
Really? Date#() function is used to convert a text field into a actual date. Are you sure it is text? Have you tried creating a chart with YourDate as dimension and Num(YourDate) as expression and see if you can see the numeric representation of dates? or do you see null?
For the second part, are you saying that when after 17-Feb you will need to use 2016? and before you will be using 2015? For all dates or only the dates after 17-Feb?