Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning All,
Could anyone assist with converting the time stamp in the attached document to a date.
Thanks
H
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;
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
Month(Time Stamp) as Month
Day(Time Stamp) as Day
Date(Time Stamp),'MM/DD/YY' as Date
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);
Thanks, and welcome glad to help you.
Regards,
Anand