Re: date conversation - Qlik Community

bhavvibudagam · ‎2016-03-14

Hi,

Can any one please help me.

In date field i have

input output

Date Date

2/11/2015 2/11/2015

2/12/2016 2/12/2015

2/11/2017 2/11/2017

2/10/2017 2/10/2017

2/10/2018 2/10/2018

2-11-2015 2/11/2015

2-12-2014 2/12/2014

2-09-2011 2/09/2011

Their is two formats of date,can any one help me to convert 2 formats to one format as DD/MM/YYYY.

Edit by Community Team member:

He started the same topic multiple times. The topic was answered here:

Topic locked.

sunny_talwar · ‎2016-03-14

Try this:

Date(Alt(Date#([input Date], 'D/MM/YYYY'), Date#([input Date], 'D-MM-YYYY')), 'DD/MM/YYYY') as [input Date]

Sample for your attached data

SET DateFormat='DD/MM/YYYY';

Table:

LOAD *,

Date(Alt(Date#([input Date], 'D/MM/YYYY'), Date#([input Date], 'D-MM-YYYY'))) as [output Date];

LOAD * Inline [

input Date

2/11/2015

2/12/2016

2/11/2017

2/10/2017

2/10/2018

2-11-2015

2-12-2014

2-09-2011

];

gardenierbi · ‎2016-03-14