topic Re: change Date Format in Qlik Learning Discussions

change Date Format

Fri, 17 Oct 2014 17:16:59 GMT

Hi Guys,

I Have these Kind of date formats

Row1 12/10/2014

Row2 12-10-2014

Row3 12/10/2014

Row4 12-10-2014

. .

Rown DD/MM/YYYY

I need to change all the dates into a single format like DD:MM:YYYY.Please help me

Re: change Date Format

Anonymous — Fri, 17 Oct 2014 17:33:29 GMT

Try using this on your load:

date(alt(Date#(Data,'DD/MM/YYYY'),Date#(Data,'DD-MM-YYYY')),'DD:MM:YYYY') as Data

Regards,

Gabriel

Re: change Date Format

maxgro — Fri, 17 Oct 2014 17:40:21 GMT

load

Rown,

date(date#(replace(b, '/', '-'), 'DD-MM-YYYY'), 'DD:MM:YYYY') as date;

load * inline [

Rown,b

Row1, 12/10/2014

Row2, 12-10-2014

Row3, 12/10/2014

Row4, 12-10-2014

];

Re: change Date Format

Sat, 18 Oct 2014 03:09:28 GMT

Thank you so much guys

Re: change Date Format

Sat, 18 Oct 2014 03:13:45 GMT

Hi Guys,

Suppose field 2 should contain numeric values

Row1 12102014

Row2 12102014

Row3 adxsdfe

Row4 12102014

. .

Rown

During load I want to replace the text with 0's .please help me

Re: change Date Format

maxgro — Sat, 18 Oct 2014 08:48:53 GMT

load a, if(not IsNum(b), Repeat('0', len(b)) , b) as b;

load * inline [

a, b

Row1, 12102014

Row2, 12102014

Row3, adxsdfe

Row4, 12102014

];