Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vinod22kv
Contributor

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

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.

1 Solution

Accepted Solutions

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

Sample qvw and image attached

Capture.PNG

View solution in original post

16 Replies

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

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

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

Sample qvw and image attached

Capture.PNG

View solution in original post

Chanty4u
Esteemed Contributor III

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

what is your expected outcome?

only date?  

if yes 

try this

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

Chanty4u
Esteemed Contributor III

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

script

Tab:

load *,

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

LOAD [Last Date / Time]

FROM

(ooxml, embedded labels, table is Sheet1);

EXIT SCRIPT;myd.PNG

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

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

Chanty4u
Esteemed Contributor III

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

Oh is it? good to know.

what is your expression sunny im unable to open your app

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

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

vinod22kv
Contributor

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

Hi,

i need date and time also.

vinod22kv
Contributor

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

Hi,

i Need date and time also please.

Regards,

Vinod.