Converting Date format + Time format into a combined string
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 :
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.