Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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
Not applicable
Author

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

anantmaxx
Specialist
Specialist

Hi,

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

REGARDS,

ANANT

Not applicable
Author

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

Not applicable
Author

Thanks everyone for the help!