Discussion board where members can get started with Qlik Sense.
I have date format like :2018-10-23
it's convert into like :23-10-2018
script level and ui level please let me know.
So you want to convert to 23-10-2018? If yes, then try: Date(Date#(YourDate, 'YYYY-MM-DD'),'DD-MM-YYYY').
Date#: to tell Qlik the format of your date.
Date: to tell Qlik how your date should be displayed.
View solution in original post
iconfirm the answer of @NhanNguyen.
if the date doesn't work you can use also: DATE(makedate (left(DATE,4),mid(DATE,6,2),right(DATE,2)),'DD-MM-YYYY')
makedate forces the creation of a date
Date changes the format