Date conversion

[YADAVSLN]

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.

[NhanNguyen · Accepted solution]

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. 

[juliensaintmaxent3113]

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