Changing Date Format

[#1]

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!

[#2]

date(date#('10042003','DDMMYYYY'),'DD/MM/YYYY')

[Anonymous]

Hi,

DATE(closingDate'MM/DD/YYYY')  AS CLOSING_DATE,

REGARDS,

ANANT

[#4 · Accepted solution]

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

[#5]

Thanks everyone for the help!