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]

For time, you can do this

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

[vinod22kv]

Hi,

I need date and time aslo please.

[vinod22kv]

Thanks a lot .....

is it posible to get the date and time in single cell..

[Chanty4u]

it didnt work for me

[sunny_talwar]

You already have that to begin with

TimeStamp([Last Date / Time]) as TimeStamp

[sunny_talwar]

Hahahahaha what do you mean it didn't work

[Chanty4u]

working for me