Hi everyone, I'm a finance and IT intern and I'm working a lot with Qlikview (which I am very new to) to help the business better comprehend our accounts receivables. Right now, I have a list of 'closing dates' in the following format: 10042003 (October 4th, 2003), and I would like to change a couple things.
First I would like to make it more visually appealing by adding back slashes where necessary (i.e. 10/04/2003). How do I go about doing this?
Also, rather than having a list of thousands of dates, how can I set it up so I first select the year, then month, etc.? Sort of like a year and month filter I suppose?