Need to load the data with date and date# or timestamp or timestampe#

[vinod22kv]

franky_h79‌swuehl‌stalwar1‌sureshqv‌

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.

[sunny_talwar]

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

[sunny_talwar · Accepted solution]

Sample qvw and image attached

[Chanty4u]

what is your expected outcome?

only date?  

if yes 

try this

Date([Last Date / Time]) as Date;

[Chanty4u]

script

Tab:

load *,

Date([Last Date / Time]) as Date;

LOAD [Last Date / Time]

FROM

(ooxml, embedded labels, table is Sheet1);

EXIT SCRIPT;

[sunny_talwar]

This will just format it like date, but underlying will still be a timestamp

[Chanty4u]

Oh is it? good to know.

what is your expression sunny im unable to open your app

[sunny_talwar]

Date(Floor([Last Date / Time])) as Date

[vinod22kv]

Hi,

i need date and time also.

[vinod22kv]

Hi,

i Need date and time also please.

Regards,

Vinod.