Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Changing Date Format

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!

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

View solution in original post

4 Replies
Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

Hi,

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

REGARDS,

ANANT

Highlighted
Not applicable

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

View solution in original post

Highlighted
Not applicable

Thanks everyone for the help!