Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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);
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.
the point isn't efficiency; your solution is correct, mine it isn't
Thanks for response.