topic Re: doubt on date in QlikView

doubt on date

satishqlik — Fri, 01 May 2015 18:59:54 GMT

Hi Community,

am using below date function to get exact date.But it hasn't worked.

am attaching source file and qvw file for your reference.

LOAD Date(Date#(DMY,'DDMMYYYY'),'DD-MMM-YY') as MYDMY,

Purpose,

Name,

Amount,

Status

FROM

C:\Users\admin\Desktop\doubt.xlsx

(ooxml, embedded labels, table is Sheet1);

Pls help me out

Re: doubt on date

Anonymous — Fri, 01 May 2015 20:33:15 GMT

You need to modify your MYDMY expression:

Date(Date#(Num(DMY,00000000),'DDMMYYYY'),'DD-MMM-YY') as MYDMY,

This will left-pad your numbers for when your Day portion has only 1 digit.

Re: doubt on date

maxgro — Fri, 01 May 2015 20:49:26 GMT

LOAD Date(

alt(Date#(DMY,'DDMMYYYY'), Date#(DMY,'DDMYYYY'), Date#(DMY,'DMMYYYY'),),'DD-MMM-YY') as MYDMY,

Purpose,

Name,

Amount,

Status

FROM

doubt.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: doubt on date

Anonymous — Fri, 01 May 2015 20:52:47 GMT

Is that solution more efficient than the one I provided above?

I'm just curious, not trying to start something or anything. I'm always looking for the more efficient answer. I think mine is more readable, however.

Re: doubt on date

maxgro — Fri, 01 May 2015 21:23:38 GMT

the point isn't efficiency; your solution is correct, mine it isn't

Re: doubt on date

satishqlik — Sat, 02 May 2015 05:29:41 GMT

Thanks for response.