topic Changing Date Format in QlikView

Changing Date Format

Tue, 25 Jun 2013 13:18:03 GMT

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!

Re: Changing Date Format

Tue, 25 Jun 2013 13:19:31 GMT

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

Re: Changing Date Format

Anonymous — Tue, 25 Jun 2013 13:21:11 GMT

Hi,

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

REGARDS,

ANANT

Re: Changing Date Format

Tue, 25 Jun 2013 13:22:09 GMT

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

Re: Changing Date Format

Tue, 25 Jun 2013 13:23:10 GMT

Thanks everyone for the help!