Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
franky_h79swuehlstalwar1sureshqv
Hi,
I hve attached the excel file and i have to convert it in to date formate in qlikview,i have used date and date# functions and timestamp and timestamp# functions. if i changed the format in the excel it is working, now i need to take out the time with out changeing the format in the excel.
Thanks and Regards,
Viond.
Sample qvw and image attached
Well within the Excel, the date is read as date... if this is true for your actual source... all you need is to do this
Date(Floor([Last Date / Time])) as Date
Sample qvw and image attached
what is your expected outcome?
only date?
if yes
try this
Date([Last Date / Time]) as Date;
script
Tab:
load *,
Date([Last Date / Time]) as Date;
LOAD [Last Date / Time]
FROM
(ooxml, embedded labels, table is Sheet1);
EXIT SCRIPT;
This will just format it like date, but underlying will still be a timestamp
Oh is it? good to know.
what is your expression sunny im unable to open your app
Date(Floor([Last Date / Time])) as Date
Hi,
i need date and time also.
Hi,
i Need date and time also please.
Regards,
Vinod.