Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
satishqlik
Creator II
Creator II

doubt on date

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

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.

View solution in original post

5 Replies
Anonymous
Not applicable

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.

maxgro
MVP
MVP

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);

Anonymous
Not applicable

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.

maxgro
MVP
MVP

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

satishqlik
Creator II
Creator II
Author

Thanks for response.