Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. 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!