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.
For time, you can do this
Time(Frac([Last Date / Time])) as Time
Hi,
I need date and time aslo please.
Thanks a lot .....
is it posible to get the date and time in single cell..
it didnt work for me
You already have that to begin with
TimeStamp([Last Date / Time]) as TimeStamp
Hahahahaha what do you mean it didn't work
working for me