Converting Date format + Time format into a combined string

[Anonymous]

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 !

[sunny_talwar]

Why not just do it in the script:

TimeStamp(Date + Time) as TimeStamp

and then may be Max(TimeStamp)

[Anonymous]

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.

[sunny_talwar · Accepted solution]

May be this:

LOAD

    [Confirmation Date],

    [Confirmation Time],

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

[Anonymous]

Thanks Alot ! Rookie Error. Works like a charm