Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
rohitians
Contributor III

I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

Date(Date#('2013-02-27','YYYY-MM-DD'),'DD-MM-YYYY')

OR

Date(Date#(datefieldname,'YYYY-MM-DD'),'DD-MM-YYYY')

View solution in original post

6 Replies
Highlighted
khadeer_sparks
Valued Contributor

Re: I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

Hi

Date(DateField,'DD-MM-YYYY')

Highlighted
Not applicable

Re: I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

Date(Date#('2013-02-27','YYYY-MM-DD'),'DD-MM-YYYY')

OR

Date(Date#(datefieldname,'YYYY-MM-DD'),'DD-MM-YYYY')

View solution in original post

Highlighted
er_mohit
Honored Contributor II

Re: I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

try this

date#(date(Datefield,'YYYY-MM-DD'),'DD-MM-YYYYY')as Datefield

Highlighted

Re: I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

Highlighted
rohitians
Contributor III

Re: I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.

Highlighted
rohitians
Contributor III

Re: I have date in the format 2013-02-27 and I want to convert it to 27-02-2013 the date I am taking it from a time stamp but I am not able to convert please help.