Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks!
date(date#(DATEFIELD,'DDMMYYYY'),'DD/MM/YYYY') AS DATE
YEAR(date(date#(DATEFIELD,'DDMMYYYY'),'DD/MM/YYYY')) AS YEAR
MONTH(date(date#(DATEFIELD,'DDMMYYYY'),'DD/MM/YYYY')) AS MONTH
date(date#('10042003','DDMMYYYY'),'DD/MM/YYYY')
Hi,
DATE(closingDate'MM/DD/YYYY') AS CLOSING_DATE,
REGARDS,
ANANT
date(date#(DATEFIELD,'DDMMYYYY'),'DD/MM/YYYY') AS DATE
YEAR(date(date#(DATEFIELD,'DDMMYYYY'),'DD/MM/YYYY')) AS YEAR
MONTH(date(date#(DATEFIELD,'DDMMYYYY'),'DD/MM/YYYY')) AS MONTH
Thanks everyone for the help!