topic Re: Date issuse !!!!!!!! in QlikView

Date issuse !!!!!!!!

Fri, 02 May 2014 13:06:32 GMT

Hi All ,

I have date column with timestamp & have a 10 log files each and every log file i have a datelike below

first file

date

8/1/2013 12:00:10 AM

8/1/2013 12:00:14 AM

second file

Header 1
8/2/2013 12:00:10 AM
8/2/2013 12:00:14 AM

like i have 10 files i want to split the date and time

can u plz suggest

Re: Date issuse !!!!!!!!

swuehl — Fri, 02 May 2014 13:10:41 GMT

Henric has posted several blog posts and documents about date and time interpretation:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

Re: Date issuse !!!!!!!!

lukaspuschner — Fri, 02 May 2014 13:10:49 GMT

not sure what you exactly want. if you only want to seperate time and date from your timestamp you can use the date(Timestamp) and the time(Timestamp) functions

Re: Date issuse !!!!!!!!

Fri, 02 May 2014 13:14:15 GMT

You can specify the date format in Date and time

Date(Submit_Date,'hh:mm:ss')

and Date(Submit_Date,'MM/DD/YYYY')

Re: Date issuse !!!!!!!!

anbu1984 — Fri, 02 May 2014 13:15:29 GMT

Load Date((Timestamp#(date,'d/m/yyyy hh:mm:ss tt'))) As dt,

Time(Timestamp#(date,'d/m/yyyy hh:mm:ss tt')) As tm;

Load * Inline [

date

08/01/2013 12:00:10 AM

08/01/2013 12:00:14 AM];

Re: Date issuse !!!!!!!!

maxgro — Fri, 02 May 2014 13:16:33 GMT

date is

floor(date)

or floor([Header1])

time is

frac(date)

or frac([Header1])

Re: Date issuse !!!!!!!!

its_anandrjs — Fri, 02 May 2014 13:25:28 GMT

For Date write

=Date(date,'D/M/YYYY') as date

For Time write

Time(date,'hh:mm:ss')

Eg:-

Time('8/1/2013 12:00:14 AM','hh:mm:ss')