Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date format how to change

Hi,

I am new to QlikView.Can some someone help me pls.

I want to make date format to be change from dd/mm/yyyy to dd-mm-yyyy.How to change that.

Thanks

1 Reply
maxgro
MVP
MVP

Use interpretation function (Date#)

Then a formatting function (Date)

If your text is 26/07/2015

Date(Date#('26/07/2015', 'DD/MM/YYYY'), 'DD-MM-YYYY')

For a detailed explanation

Get the Dates Right