Date issuse !!!!!!!!

[#1]

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

[swuehl]

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

[lukaspuschner]

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

[#4]

You can specify the date format in Date and time

like

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

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

[anbu1984]

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];

[maxgro]

date is

floor(date)

or floor([Header1])

time is

frac(date)

or frac([Header1])

[its_anandrjs]

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')