Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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