Merging Cells to form a Date

[#1]

Hi,

I'm trying to merge several cells to form a fluid date, is this possible? As below:

Current:

Year	Month	Day	Hour	Minute	Second
2015	6	5	6	25	30
2015	6	11	15	8	45

Needed:

Date	Hour	Minute	Second
5/06/2015	6	25	30
11/06/2015	15	8	45

Any help would be much appreciated!

Kind regards,

Tristan Breslin

[swuehl · Accepted solution]

LOAD

     MakeDate( Year,Month, Day) as Date,

     MakeTime(Hour, Minute, Second) as Time

FROM ...;

[sunny_talwar]

To make date you can try MakeDate() function:

MakeDate(Year, Month, Day) as Date

[#4]

Great that's done it! Cheers Swuehl

[#5]

Cheers Sunny!