Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Date conversion

Hi All,

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.

 

Thanks,

Yadav.

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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

2 Replies
Highlighted
Contributor III
Contributor III

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

Highlighted

hi,

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

bye