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.
Thanks in Advance !
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:
Timestamp([Confirmed Date] + [Confirmed Time]) as Timestamp,
It says that Confirmed Date doesn't exist.