Hi guys. I have a field called [AD_Request_Date] and I want Qlikview to show me (in a text box) what the maximum date is, for that field. However, there is a date of 01/01/2099 which keeps coming up in the data which is used to signify a date which has not been entered. I would like to therefore ignore that data, and just give me the max date in the field. Can you help? Thanks
If that does not help then I would suggest applying some date functions on your AD_Request_Date in the load script so it uses the default Qlik date format. For example you probably want to do Date(Floor(Num(AD_Request_Date))) as AD_Request_Date in your load script.
James, did Chris' last post work for you? If so, please be sure to use the Accept as Solution button on his post to give him credit for the help and let others know it worked. If you did something different, consider posting that and then mark that post as the solution. If you are still working on things, leave an update.
Here are a couple of links from the Design Blog area that may be of some help:
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.