topic Re: date conversation in Scalability

date conversation

bhavvibudagam — Mon, 14 Mar 2016 08:53:23 GMT

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 — Mon, 14 Mar 2016 14:18:44 GMT

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 — Mon, 14 Mar 2016 14:35:55 GMT