Timestamp

[#1]

Morning All,

Could anyone assist with converting the time stamp in the attached document to a date.

Thanks

H

[vardhancse]

when we have a field which contains date and time:

Date:

Floor(Date(field)) as Field_Date;

Year:

Floor(Year(Field)) as Field_Year;

Time:

Floor(Time(Field)) as Field_Time;

[#3]

Hi Anand & Harshal,

Thank you both for your contributions, I have a solution.

Anand, you were the first to spot the need for the 'TT' in all the responses, however, Harshal thanks for pointing out that when you floor the date it reverts to a numeric number like 41477, and thus the need for properties>number>date.

Much appreciated

H

[rido1421]

Month(Time Stamp) as Month

Day(Time Stamp) as Day

Date(Time Stamp),'MM/DD/YY' as Date

[maxgro]

Directory;

LOAD

[Time Stamp],

Date( Timestamp#([Time Stamp],'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY hh:mm:ss') as Date

FROM [Time Stamp.xlsx] (ooxml, embedded labels, table is Sheet1);

[its_anandrjs]

Thanks, and welcome glad to help you.

Regards,

Anand