Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Converting Date format + Time format into a combined string

Hi,

Timestamp is used to convert string into Date formats and Time formats.  I'd like to find a way to do it the other way around.

Example below :

Date:                    Time:

11/06/2016               14:12:15 PM

Lets say I am interested in knowing the when the first date of sale of an article was or the last date.  Thus i was thinking of simply using Max(date) and Max(time) and min(date) min (time).  I can use this because the sheet object I am using to show the data is a pivot table, thus it would relate it properly to the relevant article.  However, I wish to represent the Article in one column and (date and time) in another.

Can someone please give any advice on how I can combine the date and time in their relevant formats as in the example?

Max(date) & '' & Max(time) did not yield the required results, I am assuming it because of the formatting issues.

Thanks in Advance !

1 Solution

Accepted Solutions
Highlighted

Re: Converting Date format + Time format into a combined string

May be this:

LOAD

    [Confirmation Date],

    [Confirmation Time],

    Timestamp([Confirmation Date] + [Confirmation Time]) as Timestamp,

View solution in original post

4 Replies
Highlighted

Re: Converting Date format + Time format into a combined string

Why not just do it in the script:

TimeStamp(Date + Time) as TimeStamp

and then may be Max(TimeStamp)

Highlighted
Creator III
Creator III

Re: Converting Date format + Time format into a combined string

Where do i do it in the script? 

If i do it underneath the Load statement, it doesnt work.

See below example of the script:

LOAD 

     [Confirmation Date],

     [Confirmation Time],

     Timestamp([Confirmed Date] + [Confirmed Time]) as Timestamp,

It says that Confirmed Date doesn't exist.

Highlighted

Re: Converting Date format + Time format into a combined string

May be this:

LOAD

    [Confirmation Date],

    [Confirmation Time],

    Timestamp([Confirmation Date] + [Confirmation Time]) as Timestamp,

View solution in original post

Highlighted
Creator III
Creator III

Re: Converting Date format + Time format into a combined string

Thanks Alot ! Rookie Error. Works like a charm